Interested to Buy Any Domain ? << Click Here >> for more details...
wht target override?wht advantages it has compare to target
update?
- 2 Answers
- 13917 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 |
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
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 are the scheduling options to run a sesion?
HOW TO DELETE A RECORD FROM FLAT FILE
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
Explain the scenario which compels informatica server to reject files?
SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?
Repository user profiles
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Teradata 
