Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17 Answers
- 42835 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / raji
Just keep one transformer stage before funnel stage.Three
links(from three tables) should be coming as input for this
transformer. For the first link add the other tables
columns and so on.Make all the links have same number of
output columns. It should have same metadata definitions. i
mean these three links should contain all the 9 columns or
whatever it is.Now you can proceed further.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
How will you move hashed file from one location to another location?
How to read the length of word in unix?
Define Routines and their types?
Difference between sequential file and data set?
Explain datastage architecture?
What is the precedence of stage variables,derivations, and constraints?
How the ipc stage work?
What is the use of datastage designer?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How you can fix the truncated data error in datastage?
What are the primary usages of datastage tool?
What is the purpose of interprocessor stage in server jobs?
Where the datastage stored his repository?
What are stage variables and constants?
