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?
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 |
Normalizer transformation is not involved in Mapplet.. why???
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
generate date / time dimension in informatica
Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?
we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.
How do you load first and last records into target table?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
how we can load rejected record's at run time?(not through bad files)
can you use flat file for repository?why?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
how DTM buffer size and buffer block size are related