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
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 |
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
How do you find the number of rows in a sequential file?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
What is the difference between orabulk and bcp stages?
How do you import and export data into datastage?
Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?
How do you generate sequence number in datastage?
Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How do you reject records in a transformer?
how to handle null values in sequential file?