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
What are the types of schemas we have in data warehouse and what are the difference between them?
Define the various join types of joiner transformation?
What is data movement mode in Informatica and difference between them?
What is expression transformation?
Define pmcmd command?
What is workflow? What are the components of workflow manager?
What is a stored procedure transformation?
How to use procedural logic inside infromatica?
How many dimensions are there in informatica?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What does reusable transformation mean?
What is the sequence generator transformation in informatica?
What are roles and groups and benefits of using them?
Where do we use mapping variables in informatica?
What do you mean by enterprise data warehousing?