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
- 37840 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
What is the use of hoursfromtime() function in transformer stage in datastage?
What are iconv and oconv?
Differentiate between hash file and sequential file?
What are the types of views in datastage director?
What is a folder? Difference types of stages?
Describe the main features of datastage?
Define Routines and their types?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How and where you used hash file?
Why fact table is in normal form?
Why we use surrogate key?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How many areas for files does datastage have?
How do you remove duplicate values in datastage?
