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
How do you start developing a datastage project?
What is oci?
how to abort the job its matain duplicates?
What are the difference types of stages?
What is the difference between validated and compiled in the datastage?
What are stage variables and constants?
How many types of hash files are there?
What is use Array size in datastage
What is the difference between an operational datastage and a data warehouse?
Describe the architecture of datastage?
Notification Activity
How a routine is called in datastage job?
What is the difference between server job and parallel jobs?
What is active and passive stage?
What is difference between join, merge and lookup stage?