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
Can you explain repository tables in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Does datastage support slowly changing dimensions ?
sed,awk,head
How many types of hash files are there?
How do u convert the columns to rows in datastage?
What are the areas of application?
AGGREGATOR default datatype
What is the flow of loading data into fact & dimensional tables?
How to reverse the string using SQL?
What are the functionalities of link collector?
Nls stands for what in datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How to read the length of word in unix?
What are the types of containers?