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 |
How to delete the data in dataset?types of deleting the data in dataset?
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
what is usage of datastage with materialized views
1)Source file contains one record, I want 100 records in target file.
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
If you want to use the same piece of code in different jobs, how will you achieve it?
Define Data Stage?
How to Convert the columns into rows?
How do u call shellscript/Batch file from DS?
Difference between JOIN,LOOKUP,MERGE?
in aggregator , how can i get the sum in readable format