You have been working on DataStage and most of the times you have used Lookup stage for lookup data from reference link. Suddenly you heard about Sparse lookup and …
CurrentTimestamp(),CurrentDate() and CurrentTime() functions are most useful functions in DataStage when we are dealing with the jobs to get the ‘current’ date and time stamp. Generally we use these …
This is continuation for previous post. True or false: A table in Snowflake can only be queried using the Virtual Warehouse used to load the data.TRUEFALSE Which of the …
Below are the sample questions for Snowflake certification. I have gathered total 30 questions and posted them in 2 posts. Please go through them and note that answers are …
Problem Statement: Student details are stored in the following format: “Roll no,Name,Scorel,Score2” Write Unix command to display the roll no and the name of all the students whose total …
IBM DataStage Flow Designer is a web-based UI for DataStage, compared to DataStage Designer, which is a Windows-based desktop client. We can use IBM DataStage Flow Designer to create, …
Do you think whatever you are migrating that will run properly in production? I am giving some of the things here. Of course this is not a final list. …
We know we can give hard coded sheet name or parameterized sheet name while reading excel data from unstructured data stage. But the problem comes when you want to …
