Interested to Buy Any Domain ? << Click Here >> for more details...
Why use the lookup transformation ?
- 2 Answers
- 6526 Views
- Informatica, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rekha
1. GET A REALTED VALUE
2.UPDATE SLOWLY CHANGING DIMENSION
3.PERFORM CALCULATIONS
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / swetha
To perform the following tasks.
Get a related value. For example, if your source table
includes employee ID, but you want to include the employee
name in your target table to make your summary data easier
to read. Perform a calculation. Many normalized tables
include values used in a calculation, such as gross sales
per invoice or sales tax, but not the calculated value (such
as net sales). Update slowly changing dimension tables. You
can use a Lookup transformation to determine whether records
already exist in the target.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is main use of mapplet?
What are the Differences between static cache and dynamic cache?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Tell me about informatica architecture.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
As union transformation gives UNION ALL output, how you will get the UNION output?
waht is dataware house
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
what are the real time problems generally come up while doing or running mapping or any transformation?
What is source qualifier?
How to retrieve last two days updated records?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
Teradata 
