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
- 8606 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sarthak
Your Question is wrong......
this data belongs to Source table or look up table..
Multiple match principle comes in lookup table(not in source
table)..
if no. of rows in source table that connected to lookup t/f
is 3,then the output of lookup t/f is 3 rows...
it will not decrease
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / pune.rohitsharma
well my ans as we are doing look-up on source and we are
getting the records from the DB not from any other t/r
so that's y it is passive.
| Is This Answer Correct ? | 5 Yes | 5 No |
Answer / 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 |
Answer / varun4db
In this case for first row with 101 id it will give random(
either first or last or any or error). And again for second
row 101 it will return any random( either first or last or
any or error).
So the count of out put row is equal to the input row. so it
is passive only.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / akash
An active transformation handles data in groups while a
passive transformation handles them row-by-row. Lookup
handles each record one by one. So it is a passive
transformation.
| Is This Answer Correct ? | 0 Yes | 4 No |
What is the way to execute pl/sql script using informatica mapping?
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
can we have to do changes in session property when we are dynamically generating target files?
Explain what is informatica metadata and where is it stored?
What are the types of groups in Router transformation?
What are multi-group transformations?
How will you update the first four rows and insert next four rows in a mapping?
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
In informatica workflow manager, how many repositories can be created?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
in which situations do u go for snowflake schema ?
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
Teradata 
