if 3 table having different columes. like first table
having 4 columns , second table having 3 columns and third
table having 2 columns then how to capture the data by
using funnel stage in parallel jobs...srinu.thadi
Answer Posted / ajay
I am not sure abt the answer......but i think we can use
column generator for each of the inputs inorder to make
same metadata for all the 3 inputs bcos the prerequisite
for the funnel stage is metadata should be
same.........then we can funnel based on the key column
| Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
what is the use of skid in reporting?
What is the command line function to import and export the ds jobs?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the enhancements made in datastage 7.5 compare with 7.0?
What is data partitioning?
What are the steps needed to create a simple basic datastage job?
What is quality stage?
In Datastage, how you can fix the truncated data error?
why do u need the IOS upgradation in a FC switch
Describe stream connector?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How many types of sorting methods are available in datastage?
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