Interested to Buy Any Domain ? << Click Here >> for more details...
wht target override?wht advantages it has compare to target
update?
- 2 Answers
- 13687 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 |
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
how many session run unix environment what command using ?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.
What is the use of code page?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
why we r using presql&postsql in source qualifier?
Under what condition selecting sorted input in aggregator may fail the session?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
Can we write to_date(three arguments) ? Will it work ? Advance thanks
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
Teradata 
