Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 34843 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / ram reddy
Update Override it is an option available in TARGET
instance.By defalut Target table is updated based on
Primary key values.To update the Target table on non
primary key values u can generate the default Querey and
override the Querey according to the requiremnet.Suppose
for example u want to update the record in target table
When a column value='AAA' then u can include this condition
in where clause of default Querey.
Coming to SQL override it is an option available in Source
Qualifier and Lookup transafornmation where u can inlude
joins ,filters,Group by and order by.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
How many ways a relational source definition can be updated and what are they?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is fact table? Explain the different kinds of facts.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
expain about the tune parameters?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is an aggregator transformation?
What is parallel processing in informatica?
Explian the Process of deployment groups in informatica
explain about unit testing? in real time?
What is flashback table ? Advance thanks
What is difference between a gateway node and worker node?
Enlist few areas or real-time situations where informatica is required.
