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
- 43345 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
Explain connectivity between datastage with datasources?
What is aggtorec restructure operator?
How many types of sorting methods are available 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 to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What all the types of jobs you developed?
What is datastage?
Explain the importance of surrogate key in data warehousing?
What is the difference between odbc and drs stage?
What is the difference between validated and compiled in the datastage?
How do you import and export data into datastage?
What is the flow of loading data into fact & dimensional tables?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What is the difference between account and directory options ?
Lookup constraints
