Interested to Buy Any Domain ? << Click Here >> for more details...
How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)
- 5 Answers
- 10044 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / moorthy g [ibm]
1. Target Update Override
2. Select Unique Value (means)
Exp:
out_flag: decode( true, pre_no=no, 'Y', 'N')
pre_no = no
Router:
Out_flag: Y --- Unique Value
Default --- Duplicate Value
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is the need of etl tools?
what is informatica metadata?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is expression transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How many transformations can be used in mapplets.
What is DR strategy for Informatica project?
If informatica has its scheduler why using third party scheduler?
How to load a Dimension ? and how to load a fact table?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are pre and post-session shell commands?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
