Interested to Buy Any Domain ? << Click Here >> for more details...
what is target update override and when we use it?
- 2 Answers
- 6903 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / moorthy g
Whenever the source table have non key columns but I want to
update in the target table then you have to go for target
update override.
Target Properties - Update Override - give some update
condition.
Correct me If I'm wrong
Thanks
Moorthy
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Explian the connected and unconnected lookup transformation
why we use source qualifier transformation?
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
Can we create two repositories on same database instance in oracle?
What is predefined event?
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,
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
Tell me one complex query in oracle ?
How can we delete duplicate rows from flat files?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
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 do we implement materialized view?when to use materialized view?
Teradata 
