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
- 44061 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the steps needed to create a simple basic datastage job?
what is the use of skid in reporting?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are stage variables?
What is datastage?
What are the different common services in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what are the devoleper roles in real time? plz tell i am new to datastage....
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What are routines in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Explain Quality stage?
What are stage variables and constants?
What are datastage sequences?
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.
