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
- 44060 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 |
Explain entity, attribute and relationship in datastage?
Does datastage support slowly changing dimensions ?
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
What is the difference between validated and compiled in the datastage?
In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario
What are orabulk and bcp stages?
I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
what is the difference between == and eq in UNIX shell scripting?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
what is the definitions for Datawarehose and Datamart?
Teradata 
