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?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
how do u capture duplicates through sort & transformer
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
Can we use sequential file as source to hash file? Have you do it ?if what error it will give?
What are the enhancements made in datastage 7.5 compare with 7.0?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del