Describe two levels in which update strategy transformation
sets?
Answer / swetha
Within a session. When you configure a session, you can
instruct the Informatica Server to either treat all records
in the same way (for example, treat all records as inserts),
or use instructions coded into the session mapping to flag
records for different database operations.
Within a mapping. Within a mapping, you use the Update
Strategy transformation to flag records
| Is This Answer Correct ? | 7 Yes | 2 No |
What is a transaction control transformation?
How do you create single lookup transformation using multiple tables?
How to create a non-reusable instance of reusable transformations?
List the transformation in informatica.
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Diffrence between static and dynamic cache
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
In dimension and fact table? which one holds big data?
create a mapping to retrieve the employees who are getting salary greater than average salary?
How we can confirm all mappings in the repository simultaneously?