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 |
What is the difference between odbc and drs stage?
What are system variables and sequencers in datastage
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
when we will use connected Lookup & Unconnected Lookup
source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........
How to lode data in sequntional files perform faster?
Can you define merge?
where we use config file as parameter ?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
Wat is isolation level and when do u use them?
which is more expensive hash or modulus partitioning? when do you use modulus partitioning?