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
How to extract the informatica rejected data?
What is meant by LDAP users?
In informatica workflow manager, how many repositories can be created?
Explain the aggregator transformation?
Is there any way to read the ms excel datas directly into informatica?
What is the different lookup cache(s)?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How do you update the records with or without using update strategy?
What is union transformation in informatica?
Can we create two repositories on same database instance in oracle?
How to partition the Session?
What is the fact table?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How is union transformation utilized?
Define filter transformation?