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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If you want to use a same piece of code in different jobs, how will you achieve this?

796


What is difference between join, merge and lookup stage?

638


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2428


What is active and passive stage?

876


why do u need the IOS upgradation in a FC switch

1875






How to perform incremental load in datastage?

668


How you can fix the truncated data error in datastage?

1207


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2052


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?

1746


Difference between in process and inter process?

701


How many types of stage?

678


What is the process of killing a job in datastage?

593


Have you used Unstructured data?

834


Explain how a source file is populated?

765


how to export or import the jobs in .ISX file

721