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
- 42649 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
Define repository tables in datastage?
What are the different layers in the information server architecture?
Difference between data warehousing and olap?
what is the use of skid in reporting?
root tree will find which is server job and which is parallel job?
What is the difference between hashfile and sequential file?
AGGREGATOR default datatype
What is a merge?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How to reverse the string using SQL?
Explain how a source file is populated?
Have you have ever worked in unix environment and why it is useful in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
