Interested to Buy Any Domain ? << Click Here >> for more details...
Hi all, i am new to this site and new to Informatica too. I
have few questions regarding that.
1) When we load flat files into target tables how do we
identify duplicates? and where do load the duplicate
records for further reference?
2) How do we do chage data capture? Is this Slowly changing
Dimension technique?
Thanks in Advance
- 3 Answers
- 7105 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
BEFORE LOADING THE DATA IN TO THE TARGET , U CAN CRETAE THE
ROUTER TRANSFORMATION AND PASS THE CONDITION FOR DUPLICATE
ROWS .
YES SCD EXPLAINS THE CHANGED DATA CAPTURE IN TO THE TARGET
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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?
define galaxy repository in informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain what transformation and how many are there in informatica?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How to update or delete the rows in a target, which do not have key fields?
What are connected or unconnected transformations?
How to generate sequence numbers using expression transformation?
What are the measure objects?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain direct and indirect flat file loading (source file type) - informatica
How an expression transformation differs from aggregator transformation?
What is data transformation manager process?
What is persistent lookup cache?
Explain the difference between mapping parameter and mapping variable?
