How to extract original records at one target & Duplicate
records at one target?

Answers were Sorted based on User's Feedback



How to extract original records at one target & Duplicate records at one target?..

Answer / rag

Hi You can do this another way also
put the expresession transforamtion and read some previous
record with the currect record or any unique column value in
the expression and if they are equal then assign the
flag(means duplicate flag) else
assign the new flage.
pass the duplicate flag records to the filter and goes to
the TB(duplicate records target) and unique values to the
origonal target

Is This Answer Correct ?    0 Yes 2 No

How to extract original records at one target & Duplicate records at one target?..

Answer / saradhi

As of my knowledge i think its possible by Router
Transformation.By writing one condition we can extract the
data with out duplication in one target then automatically
default records means with duplication are transferred in
to another target.

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Informatica Interview Questions

Explain sessions and how many types of sessions are there?

0 Answers  


can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,


Differentiate between a repository server and a powerhouse?

0 Answers  


how did u understand business requirement?

2 Answers   TCS,


what is the predefined port in dynamic lookup

2 Answers  






Where do you create/define mapping parameter and mapping variable?

1 Answers  


Which version configuration tool used in ur project?

0 Answers   CTS, TCS,


What is data caches/ index caches?

0 Answers  


HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers   Cap Gemini,


A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,


how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,


What are the new features of informatica 9.x at the developer level?

0 Answers  


Categories