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


Please Help Members By Posting Answers For Below Questions

What are the different options associated with dsjob command?

929


How do you reject records in a transformer?

624


How to read the length of word in unix?

878


What steps should be taken to improve Datastage jobs?

633


Explain the datastage parallel extender (px) or enterprise edition (ee)?

722






What are the components of datastage?

643


What are the functionalities of link collector?

623


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.

2424


What are the different kinds of views available in a datastage director?

594


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2071


Describe link sort?

636


What are the different plug-ins stages used in your projects?

617


what are the devoleper roles in real time? plz tell i am new to datastage....

1630


What are data elements?

651


What is process model?

1547