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
- 7231 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
What are the new features of Power Center 5.0?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How to generate sequence numbers using expression transformation?
How to use procedural logic inside infromatica?
Explain the scenario which compels informatica server to reject files?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How might one distinguish in the case of mapping is right or not without associating session?
What is a transaction control transformation?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is the format of informatica objects in a repository?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Can we create a Integration service without a Repository service and vice versa?
Mention few power centre client applications with their basic purpose?
What are the reusable transformations?
What do you mean by filter transformation?
