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


Please Help Members By Posting Answers For Below Questions

Differentiate between Join, Merge and Lookup stage?

857


Why fact table is in normal form?

900


Explain the importance of surrogate key in data warehousing?

935


how to abort the job its matain duplicates?

2337


Differentiate between operational datastage (ods) and data warehouse?

914


What are the different layers in the information server architecture?

865


What are the stages in datastage?

833


Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1837


How to convert RGB Value to Hexadecimal values in datastage?

3693


What are the important features of datastage?

838


how to write server Routine coding?

1872


What is a datastage job?

798


What are the partitioning techniques available in link partitioner?

2034


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

2226


Describe the main features of datastage?

860