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 / prasu
Put the transformer before the 2 tables which u have
lesscolumns.
and then add the remaning columns for the 2 tables.then
join with funnel stage
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the purpose of interprocessor stage in server jobs?
Explain ibm infosphere information server and highlight its main features?
What is a merge in datastage?
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
How many types of hash files are there?
EXPLAIN SCD
What are the some differences between 7.x and 8.x version of datastage?
How can you write parallel routines in datastage PX?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Difference between in process and inter process?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Explain Quality stage?
What are data elements?
Name the different types of Lookups in Datastage?
What is the importance of the exception activity in datastage?