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 reusable transformations?
How to create the source and target database connections in server manager?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the sql query overwrite in source qualifier in informatica
What is depict expression change?
Describe data concatenation?
Where can we find the throughput option in informatica?
permutations of mapplet
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is exclusive and normal mode for repository services?
Enlist few areas or real-time situations where informatica is required.
What are the modules in Power Center
How is union transformation utilized?
What are the databases that informatica can connect to windows?