Please Tell me..,I need some Complex Jobs in datastage as
per in interview?how to tell and how to explain?please send
as well as posiible please
Answer / sai
Hi,
The answer for above question will vary from project to
project.
In my project CRIS RAILWAYS we have used datastage 8.1 and
created so many parallel jobs.
Explain any of ur project job (even it is easy or hard)
with details...
| Is This Answer Correct ? | 6 Yes | 3 No |
Why we use surrogate key?
How do y read Sequential file from job control?
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Define Merge?
1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran
what is initial load and incremental load
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is a quality stage?
How to convert table data into xml file using xml output stage? please explain step by step;