Interested to Buy Any Domain ? << Click Here >> for more details...
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 do you mean incremental aggregation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to update a particular record in target with out running whole workflow?
What is a mapplet/worklet in informatica?
Explain what are the different types of transformation available in informatica.
What are the features of complex mapping?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How can one identify whether mapping is correct or not without connecting session?
What is lookup change?
How to extract sap data using informatica?
scenario where i can use only concurrent execution of workflow.
What is resilience time?
