what is target update override and when we use it?
Answer Posted / ankur saini er.ankur861@gmail.
Hi
Even if the table has key columns but as per some
requirement you dont want to update the records based on
that key column in this scnario also we can use update
overide to update the records based on our desired column
(s) other than primary index(td) or primary key(oracle)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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
Write the program through which the records can be updated?
How are indexes created after completing the load process?
Explain sessions?
Is it possible to create multiple domains on a single Informatica server?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the mapping variable usage example in informatica
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is Cognos script editor?
How do we call shell scripts from informatica?
Explain what is informatica metadata and where is it stored?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the different types of transformation available in informatica.
Explain sessions. Explain how batches are used to combine executions?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.