Answer Posted / 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 |
Post New Answer View All Answers
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
As union transformation gives UNION ALL output, how you will get the UNION output?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Differentiate between reusable transformation and mapplet.
What do you understand by SOA of Informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is a predefined event?
If informatica has its scheduler why using third party scheduler?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what is the complex transformation you used in informatica
What is a standalone command task?
Scheduling properties,whats the default (sequential)
What is the commit type if you have a transaction control transformation in the mapping?
What are the types of caches in lookup? Explain them.
how to load rows into fact table in data warehouse