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 / chowdary

As:1
Frist you find common columen from the 3 table then you
can use funnel stage
in funnel stage set the properte KEY= COOMON COLUMEN

Chowdary

Is This Answer Correct ?    3 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2746


Enlist various types of routines in datastage.

645


Define Routines and their types?

620


What is difference between server jobs & parallel jobs?

625


What are the various kinds of the hash file?

664






what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2181


What is the difference between validated and compiled in the datastage?

703


Where the datastage stored his repository?

617


What are stage variables?

638


How can we improve performance of data stage jobs?

616


Can you explain players in datastage?

706


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

1911


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1807


What is the difference between datastage and informatica?

612


What are the types of hashed files in data stage

646