Interested to Buy Any Domain ? << Click Here >> for more details...
wht target override?wht advantages it has compare to target
update?
- 2 Answers
- 13923 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva
Target Update (by using Update strategy) will work only
when we have the Primary key in Target. Update override
will happen based on this key.If we don't have the Pkey
Update override will not work.
To overcome the above issue..If our Target is not having
any key column or if we want to update the Target based on
a column other than PKey column then we need to go for
Target Update override option available in Target
properties.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / rkumar.etl
when table is having huge amount of records and performance
is the key factor to implement the target overrride ..if we
use update override it will take more time than the target
override.
| Is This Answer Correct ? | 4 Yes | 3 No |
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is the main difference between a Joiner Transformation and Union Transformation?
Can we create two repositories on same database instance in oracle?
Enlist the differences between database and data warehouse.
what is the logic will you implement to load data into a fact table from n dimension tables?
Explain sessions?
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
In which circumstances that informatica server creates Reject files?
In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
how tokens will generate?
Teradata 
