Interested to Buy Any Domain ? << Click Here >> for more details...
what is target update override and when we use it?
- 2 Answers
- 6780 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 |
What is data movement mode in Informatica and difference between them?
What is confirmed dimension with scenario
Why the workflow is failed after running two hours in informatica?
How can we handle two sessions in informatica?
What is expression transformation?
TELL ME ABOUT WORK FLOW SCHEDULING?
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
Design time, run time. If you don't create parameter what will happen
Can we get 1st record through Informatica(without sequence number).
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
What is partioning?how many types of partinings are there
Teradata 
