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 are the different options associated with dsjob command?
How do you reject records in a transformer?
How to read the length of word in unix?
What steps should be taken to improve Datastage jobs?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the components of datastage?
What are the functionalities of link collector?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are the different kinds of views available in a datastage director?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Describe link sort?
What are the different plug-ins stages used in your projects?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are data elements?
What is process model?