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 / ajay
I am not sure abt the answer......but i think we can use
column generator for each of the inputs inorder to make
same metadata for all the 3 inputs bcos the prerequisite
for the funnel stage is metadata should be
same.........then we can funnel based on the key column
| Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
Define data aggregation?
What is the difference between operational data stage (ods) and data warehouse?
sed,awk,head
what are the errors,warnings in datastage
Enlist various types of routines in datastage.
how do u catch bad rows from OCI stage? And what CLI stands for?
What is the difference between Datastage 7.5 and 7.0?
What is a merge in datastage?
What are routines in datastage?
Define Data Stage?
What are the components of ascential data stage?
Nls stands for what in datastage?
How do you import and export data into datastage?
Triggers,VIEW,Procedures
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE