Why use the lookup transformation ?
- 2 Answers
- 5583 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 |
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
Briefly explain the aggregator transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
Does Facttable Normalized or Denormalized?
Which version configuration tool used in ur project?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is substr in informatica?
What is target designer and target load order?
1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.
Under which circumstances, informatica server creates reject files?
Teradata 
