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 / madhusudhan

If you want combine 3tables with different column name.
First use modify stage between source and funnel stage.
change the cloumns name in the 3tables into standard format.

or

you can try with transformer for creating new column name
for each table.

mailme if you have queries.
samala.madhu@gmail.com

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between an operational datastage and a data warehouse?

637


What is a quality stage in datastage tool?

632


what is flow of project?

1559


What can we do with datastage director?

675


Could anyone give brief explanation bout datastage admin

1973






What is the difference between passive stage and active stage?

824


How a source file is populated?

620


What all the types of jobs you developed?

667


why do u need the IOS upgradation in a FC switch

1875


What is the difference between operational data stage (ods) and data warehouse?

675


Demonstrate experience in maintaining quality process standards?

1939


Difference between ‘validated ok’ and ‘compiled’ in data stage?

677


How do you import and export data into datastage?

703


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3759


What is the use of datastage director?

590