Interested to Buy Any Domain ? << Click Here >> for more details...
How will you update the row without using update statergy?
- 10 Answers
- 14956 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / ganesh
1) If the target table doesn't have primary key, then using
update override we can update the records.
2) If target table have primary key, then we have option
called update else insert in session properties. Based upon
that we will update the records.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is persistent lookup cache?
How to generate sequence numbers without using the sequence generator transformation?
Why do you use Mapping Parameter and mapping variable?
Please let me know how to make Data masking in informatica..
Tell me about MD5 functions in informatica
How to start a workflow using pmcmd command?
Explain the types of lookup transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How would you copy the content of one repository to another repository?
Explain sessions?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the cumulative sum and moving sum?
Could you explain what is enterprise data warehouse?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
