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
What is the difference between an operational datastage and a data warehouse?
What is a quality stage in datastage tool?
what is flow of project?
What can we do with datastage director?
Could anyone give brief explanation bout datastage admin
What is the difference between passive stage and active stage?
How a source file is populated?
What all the types of jobs you developed?
why do u need the IOS upgradation in a FC switch
What is the difference between operational data stage (ods) and data warehouse?
Demonstrate experience in maintaining quality process standards?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How do you import and export data into datastage?
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...
What is the use of datastage director?