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 |
Is it possible to revert a global repository to local one and why?
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
without dynamic lookup transformation how to insert new rows and update existing rows?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
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,
To achieve the session partition what r the necessary tasks u have to do?
hi all, Can anyone please tell me the relationship between informatica and business objects
What is the difference between lookup override and souce qualifier override ?
explain about informatica server architecture?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what is parallel querying and what r hints.