Interested to Buy Any Domain ? << Click Here >> for more details...
lookup is passive y can't it be active?
let us say i have some records in my source like
101,rohit,1000
101,rohit,1000
102,kumar,2000
like wise
now as it is having multiple matches i return only
first,last value it can't return bouth the values
that means lookup is acting as select distinct right by
default what means it is active?
- 5 Answers
- 8435 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / kannan
Simple logic here,
1) SQ passes the records one by one(logical field values
eg . customer id) to lkp up t\f.
2) Then, with this logicl field values , it looks into the
database( source \target db,provided cache is disabled in
properties), fetched the records(only look up enabled
columns) and passed to the down transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Parameter and variable differences
Sequence generator, when you move from develoment to production how will you reset
How can you define user defied event?
What is the Rank index port in Rank transformation?
What are the types of schemas we have in data warehouse.
Define sessions in informatica etl?
What is aggregator transformation in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the uses of etl tools?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is an expression transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How do you load only null records into target? Explain through mapping flow.
what is $$$$?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
