what is target update override and when we use it?
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
Target Properties - Update Override - give some update
Correct me If I'm wrong
|Is This Answer Correct ?||2 Yes||0 No|
Answer / ankur saini er.ankur861@gmail.
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 are the new features of the server manager in the informatica 5.0?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
What are the different transaction levels available in transaction control transformation?
what is sql override?what is the use of it?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID email@example.com
how to improve performence by using sorted input in aggrigator t/r.
Hi I have a source (flat file) like ID Name Attachments 101 abc _CMM27-11-01 Page106 (2).pdf 102 bcd "_Anfrage-Vendors.doc _Anfrage.xls" 103 def "_IMG_0310.JPG 19012006092631]_IMG_0311.JPG _IMG_0312.JPG _IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc _CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd _Anfrage.xls 103 def _IMG_0310.JPG 103 def _IMG_0311.JPG 103 def _IMG_0312.JPG 103 def _IMG_0313.JPG 103 def _IMG_0314.JPG 103 def _IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
what is the difference between Informatica 7.1 and Abinitio?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?