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 datastage and informatica?
Differentiate between odbc and drs stage?
What is datastage?
Lookup constraints
What are the differences between datastage and informatica?
How do you schedule or monitoring the job?
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...
Differentiate between data file and descriptor file?
what is the difference between == and eq in UNIX shell scripting?
What could be a data source system?
Name the different sorting methods in datastage.
Differentiate between validated and Compiled in the Datastage?
What is the flow of loading data into fact & dimensional tables?
What are the various kinds of containers available in datastage?
Why we use surrogate key?