Interested to Buy Any Domain ? << Click Here >> for more details...
What is the method of seperating unique and duplicate
records in session level?
- 2 Answers
- 10133 Views
- Emphasis, JBL, Wipro, I also Faced
- E-Mail Answers
Answer Posted / priya yadav
Hi,
I am not aware at session level but I can tell you the same
at mapping level.
Either Select Distinct in SQ itself or in expression, u can
use a variable v1 to store the business keys of the
records. This will store the business keys(based on which
you have to determine a record as duplicate) of the record
v1= A||B||C
Assign this to another variable v2. This will assign these
business keys to v2.
v2=v1( Now v2 will have value A||B||C)
Set Duplicate Flag as Y if V1= V2 else N.
Now the business keys are stored in v2. Next time the
record will come it will calculate v1 on basis of business
keys, if that record is duplicate v1=v2, and record will be
marked for duplicate. If the record has different business
keys then v1 <> v2, and the record will not be marked as
dupliacte.
Hope it helps.
Thankyou!!
Priya Yadav
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why update strategy and union transformations are active? Explain with examples.
can we override a native sql query within informatica? Where do we do it?
What are the types of schemas we have in data warehouse and what are the difference between them?
How can we use mapping variables in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
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
Define filter transformation?
What is the maplet?
What will be the approach?
What are the main issues while working with flat files as source and as targets ?
Explain pmcmd command usage in informatica
What are the restrictions of union transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
Enlist the various types of transformations.
what is Active lock explain
