Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What is the method of seperating unique and duplicate
records in session level?

Question Posted / mehul.thakur

Answers were Sorted based on User's Feedback



What is the method of seperating unique and duplicate records in session level? ..

Answer / jz

Select Distinct Box at Source propeties level or jus
override sql in Session.

Is This Answer Correct ?    17 Yes 3 No

What is the method of seperating unique and duplicate records in session level? ..

Answer / 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

More Informatica Interview Questions

Why we use partitioning the session in informatica?

2 Answers  

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

All active transformations r passive or not?

7 Answers  

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

What is the command used to run a batch?

0 Answers  

what is galaxy repository?

2 Answers  

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

what is upstream and downstream transformation?

7 Answers  

what is materialized view?

2 Answers  

How are parameters defined in informatica?

3 Answers   HP, TCS,

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

Define the various join types of joiner transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories