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 |
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
How to reverse the string using unix?
how to design the change capture stage in(data stage parallel jobs) type 2
What is ibm datastage flow designer?
How can you write parallel routines in datastage PX?
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
how to get the unique records on multiple columns by using sequential file stage only
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
How you can fix the truncated data error in datastage?
Demonstrate experience in maintaining quality process standards?
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?