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
- 43470 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivas
funneling should have same meta data.
there r three types of funnel
1) continuous funnel
2) sort funnel
3) sequential funnel
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krish
regarding this problem we can capture da common data only
which column are identical in all inputs.funnel receives
only common meta data fields from inputs & leaves un manched
meta data fields
ex;
let we have one field like a in t1 & field a's data like
1
2
3
4
then we have two field like a,b in t1 & fields a,b's data like
1 2
2,3
2,5
3,6
funnel data gives the out put only identical fields data like
1
2
3
4
1
2
2
3
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sumit
You can achive this by using Column Import,Funnel and
Column Export stages.
Thanks
Sumit
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / 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 |
Answer / chowdary
As:1
Frist you find common columen from the 3 table then you
can use funnel stage
in funnel stage set the properte KEY= COOMON COLUMEN
Chowdary
| Is This Answer Correct ? | 3 Yes | 19 No |
What are the types of hashed files in data stage
How and where you used hash file?
how can find maximum salary by using Remove duplicate stage?
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
what is snow flack schema?
what is difference between migration project and integration project? can anyone explain with the example Thanks in advance
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
How to implement complex jobs in data stage?
i want job aborted after some records are loaded into output by using only sequential stage and dataset
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
Give example for FACTLESS FACT TABLE in real-time scenario.
Teradata 
