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
- 10110 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
How to handle decimal places while importing a flatfile into informatica?
Slowly changing dimensions, types and where will you use them
What is the function of union transformation?
what are 3 tech challenges/ common issues you face?
how many types of dimensions are available in informatica?
Explain the types of transformations?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
If informatica has its scheduler why using third party scheduler?
What is an active transformation?
What is the commit type if you have a transaction control transformation in the mapping?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
how to load rows into fact table in data warehouse
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How to elaborate powercenter integration service?
