DataStage Scenario based Interview Questions
Some Interview Questions and Scenario -
http://www.datagenx.net/p/datastage-scenario.html
http://www.datagenx.net/p/datastage-posts.html
http://datastage4you.blogspot.in/p/blog-page_15.html
| Is This Answer Correct ? | 2 Yes | 1 No |
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?
Describe the main features of datastage?
What are the types of containers?
convert yyyy mm dd to dd mm yyyy?
where the log files or tables can store in DS?
Name the different sorting methods in datastage.
what is a nodemap constraint
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?