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 purpose of interprocessor stage in server jobs?
What are the important features of datastage?
How do you generate sequence number in datastage?
How do you import and export data into datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are stage variables and constants?
What is the use of datastage director?
What is the difference between orabulk and bcp stages?
What is oci?
What are the different types of lookups in datastage?
why do u need the IOS upgradation in a FC switch
How and where you used hash file?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are the types of hashed files in data stage
If you want to use a same piece of code in different jobs, how will you achieve this?