what is the look up transformation?
Answers were Sorted based on User's Feedback
Answer / ashis
Add to sweta's answer:
We use lookup transformation to lookup data from a
relational table, view, synonym or flatfile against another
or the same table, view, synonym or flatfile.
This is mainly(not only)used for SCD's. So that the value
in the source can be compared with the existing target.
Lookup transformation are of different types named and
unnamed.
Mostly used lookup transformation types are Connected lookup
(Persistent Lookup, Dynamic lookup, Cached lookup, Uncached
lookup)
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / swetha
Use lookup transformation in u'r mapping to lookup data in a
relational table, view, synonym.
Informatica server queries the look up table based on the
lookup ports in the transformation. It compares the lookup
transformation port values to lookup table column values
based on the look up condition.
Is This Answer Correct ? | 1 Yes | 1 No |
What is intricate mapping?
How you can differentiate between connected lookup and unconnected lookup?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
What is junk dimention?
When we are using Dynamic Cache,which options we will select in session level?
What is session task and command task?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
what is the size of u r project? and what is the size of source file?
without dynamic lookup transformation how to insert new rows and update existing rows?
what are the Methods For Creating Reusable Transformations?
What is union transformation?
What is a standalone command task?