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 is the use of datastage director?

595


Define Data Stage?

649


How do u convert the columns to rows in datastage?

696


What is the sortmerge collector?

672


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2019






how to export or import the jobs in .ISX file

726


Can you explain tagbatch restructure operator?

707


What are the types of jobs we have in datastage?

678


What is datastage engine?

733


What are the difference types of stages?

633


Where do the datastage jobs get stored?

739


Explain the situation where you have applied SCD in your project?

1568


What are the steps required to kill the job in Datastage?

693


What are the types of containers?

699


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1729