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

table actions available in oracle connector?

1380


how to delete one row in target dataset

2864


What are the different layers in the information server architecture?

886


Define repository tables in datastage?

933


What are some prerequisites for datastage?

868


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

921


Enlist various types of routines in datastage.

911


what is the custome stage in datastage? how can we impliment that one? plz tell me

2167


Does datastage support slowly changing dimensions ?

873


How do you generate sequence number in datastage?

866


What is staging variable?

850


Can you explain players in datastage?

983


Define Data Stage?

871


Could anyone give brief explanation bout datastage admin

2191


file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

745