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 is status code in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to go to the older version for a mapping?
How union transformation is used?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the mapping parameters and mapping variables?
What is the cumulative sum and moving sum?
What is the different lookup cache(s)?
Under which circumstances, informatica server creates reject files?
Slowly changing dimensions, types and where will you use them
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Explain what are the different types of transformation available in informatica.
Enlist the various types of transformations.
What is the procedure for creating independent data marts from informatica 7.1?