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 == and eq in UNIX shell scripting?
How do you generate sequence number in datastage?
What are the processing stages?
What are data elements?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
table actions available in oracle connector?
What is a ds designer?
How to perform incremental load in datastage?
What is the use of datastage designer?
If you want to use the same piece of code in different jobs, how will you achieve it?
What are orabulk and bcp stages?
What is the sortmerge collector?
What are the types of containers and how to create them?
Why do we use exception activity in Datastage?
What is job control?