Showing posts with label Question. Show all posts
Showing posts with label Question. Show all posts

Friday, 24 June 2016

DataStage Quiz #2

http://www.datagenx.net/2016/06/datastage-quiz-1.html

If you are unable to see your result, Kindly wait for 5 min then click here - https://goo.gl/tFtU7o 
If you need more quizs like this, Like the page or join me over these social connections

https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://datagenx.slack.com/messages/datascience/

Monday, 18 April 2016

10 Scenario based Interview Questions #2 - DataStage



11. Design a job which insert the data if not exists and update if exists in target
12. Design a job which includes a header and footer in output file
13. Design a job which checks whether Currency data is having 'Rs. 9999.99' format or not.
14. Design a job which checks the date passed validation. Date input in YYYYMMDD format.

For more ->  DataStage Scenario

15. Design a job which check the date difference in Hrs and Mins ( HH:MM)
16. Design a job which delete the data if exists in target first and then load.
17. Design a job which check whether each column is having a value or not
18. Design a job which populate the Date dimention table.
19. Design a job which transpose the columns into row with the help of transformer stage.
20. Design a job which remove duplicate without using Remove Duplicate Stage.


For more ->  DataStage Scenario



Like the below page to get update  
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://datagenx.slack.com/messages/datascience/

Monday, 28 March 2016

10 Scenario based Interview Questions #1 - DataStage


1. Design a job which convert single source row to three target row.
2. Design a job which can identify the row if they are duplicate in input.
3. Design a job which will fetch the input file header and footer.
4. Design a job which will segregate unique and duplicate records in different files.
5. Design a job which remove the header from the input file.

For more ->  DataStage Scenario
6. Design a job which remove the footer from the input file.
7. Design a job which throw a mail if footer is not there in input file.
8. Design a job which extract the alternate records from the input file.
9. Design a job which extract the Nth row from the input file
10. Design a job which extract data from two input files and load them in alternate in target.


For more ->  DataStage Scenario

Wednesday, 2 September 2015

Download DataStage Scenarios





You can download all the old DataStage Scenario Question by Clicking the LIKE/Log In button -





Now, Click on this LINK to get the all DataStage Scenario



Tuesday, 1 September 2015

DataStage Scenario #1 - Letters in Alphabetical Order





Design a Datastage job that can determine if the letters in a word, coming as input, are in alphabetical order.





Input:
almost
banana
very
begins
order
in


Output:
almost IN ORDER
banana NOT IN ORDER
very NOT IN ORDER
begins IN ORDER
order NOT IN ORDER
in IN ORDER



For more Scenario -  CLICK HERE