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
Differentiate between Join, Merge and Lookup stage?
Why fact table is in normal form?
Explain the importance of surrogate key in data warehousing?
how to abort the job its matain duplicates?
Differentiate between operational datastage (ods) and data warehouse?
What are the different layers in the information server architecture?
What are the stages in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How to convert RGB Value to Hexadecimal values in datastage?
What are the important features of datastage?
how to write server Routine coding?
What is a datastage job?
What are the partitioning techniques available in link partitioner?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Describe the main features of datastage?