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 / 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
Why fact table is in normal form?
Explain datastage architecture?
Which algorithm you used for your hashfile?
How to RD using transformer?
What is the purpose of pivot stage?
What is the purpose of interprocessor stage in server jobs?
What is "fatal error/rdbms code 3996" error?
What are the different kinds of views available in a datastage director?
How a source file is populated?
What is quality stage?
What are the types of containers and how to create them?
What is data partitioning?
why do u need the IOS upgradation in a FC switch
What are the enhancements made in datastage 7.5 compare with 7.0?
Define oconv () and iconv () functions in datastage?