Interested to Buy Any Domain ? << Click Here >> for more details...
what is the look up transformation?
- 2 Answers
- 9846 Views
- Informatica, I also Faced
- E-Mail Answers
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 |
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
How to delete duplicate records in a flat file source?
what is upstream and downstream transformation?
what are the differences between powercenter 8.1 and powercenter 8.5?
Explain the types of transformations?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is meant by incremental aggregation?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
how to through logic of informatica using the push down optimization into oracle.
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,
Teradata 
