Can anybody tell me in detail any complex datastage job? I
have worked only in direct load and full refresh jobs.But in
all interviews this question arises
Answer / lakshmi
Working up with fact jobs is a complex one as to gather the source from multiple dimensions in to one dataset, while gathering it may endup with joining many lookups and db connectors.
| Is This Answer Correct ? | 0 Yes | 0 No |
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
what is mapping lookup
how to identifie,is it innerjoin,leftouter join in lookup?
What are the unit test cases you used in your project?
In one project how many shared containers are created?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
How complex jobs are implemented in datstage to improve performance?
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
How do you import and export the datastage jobs?
How to create environments and call them? What is the use defined variables?
How can we improve performance of data stage jobs?
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records