Answer Posted / swetha
The informatica server follows instructions coded into
update strategy transformations with in the session maping
determine how to flag records for insert,update, delete or
reject
If you do not choose data driven option setting, the
informatica server ignores all update strategy
transformations in the mapping.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the command used to run a batch?
What is the difference between stop and abort in informatica
scenario where i can use only concurrent execution of workflow.
What is the status code in stored procedure transformation?
What is exclusive and normal mode for repository services?
How can we create index after completion of load process?
What are some examples of informatica etl programs?
What is meant by query override?
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
How do you remove duplicate records in informatica? And how many ways are there to do it?
list out all the transformations which use cache?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How do you convert single row from source into three rows into target?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
how many types of dimensions are available in informatica?