Interested to Buy Any Domain ? << Click Here >> for more details...
How can u insert o ne row in the target if that row does not
exists in the target and update if it exists
- 6 Answers
- 14844 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sujana
by using scd type2 v can do dis
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is the advantage of informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the different transaction levels available in transaction control transformation?
I have a flat file, want to reverse the contents of the flat file
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is a passive transformation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What could be the possible resons of locks by user?
What does “tail –f” command do and what is its use as an Informatica admin.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are pre and post-session shell commands?
Why union transformation is an active transformation?
What is event and what are the tasks related to it?
