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
- 10083 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
difference between informatica 8.1.1 and 8.6
Briefly define reusable transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is a repository manager?
Which means the first record should come as last record and last record should come as first record and load into the target file?
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?
Informatica Checkpoints
How might one distinguish in the case of mapping is right or not without associating session?
What is native users?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Why update strategy and union transformations are active? Explain with examples.
What are the static cache and dynamic cache in informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
