Interested to Buy Any Domain ? << Click Here >> for more details...
Can we insert ,update ,delete in target tables with one
update strategy tran.?
- 2 Answers
- 11446 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / sehaj
WE CAN UPDATE INSERT ROWS INTO TARGET TABLE USING SAME
UPDATE STRATERGY IN A SESSION BUT WE NEED TO SELECT THE
OPTION UPDATE ELSE INSERT OPTION FROM SESSION
PROPERTIES>MAPPING.
BUT WE CAN INSERT UPDATE N DELETE,I MEAN PERFORM ALL THREE
AT A TIME.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What are the various types of transformation?
What can we do to improve the performance of informatica aggregator transformation?
What is meant by target load plan?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain the pipeline partition with real time example?
What are the types of caches in lookup? Explain them.
what is unit testing?tell me proceedure
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What does reusable transformation mean?
What is the use of target designer?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What do you understand by a term domain?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
if we have a delimiters at unwanted places in a flat file how can we over come those.
