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
What is quality stage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are the difference types of stages?
What are the enhancements made in datastage 7.5 compare with 7.0?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are orabulk and bcp stages?
Define APT_CONFIG in Datastage?
How will you move hashed file from one location to another location?
What is the difference between informatica and datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is the difference between in process and inter process?
How many types of sorting methods are available in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys