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

my table contain duplicate Records i wanna load uniq records
to my table . i have to pass the uniq records through
filter t/r how?

Question Posted / gangadhar799

Answers were Sorted based on User's Feedback



my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq..

Answer / pavana

Yes, Sort the data first , then in expression increment the
count based on theprev value . in filter give condition if
count =0 . it pass only unique value.

sd >> SQ>> SRT TRN>> EXP>> FIL>> TGT.

Is This Answer Correct ?    1 Yes 0 No

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq..

Answer / ganga

HI Dharmendra,


here i want to pass the uniq records through filter is possible are not?

Is This Answer Correct ?    0 Yes 0 No

my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq..

Answer / dharmendra singh

Use a sorter transformation after source qualifier.check
unique records in the proprrties of sorter,This will [ass
only unique record from the sorter.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

what is SDLC way of code development?

0 Answers  

What are the different versions of informatica?

0 Answers  

How to send duplicates to one target and unique rows to one target?target is empty

9 Answers   Amazon, IBM, Wipro,

Make a note of the quantity vaults made in informatica?

0 Answers  

Can you generate sequence numbers without using the sequence generator transformation?

0 Answers  

how many session run unix environment what command using ?

1 Answers   HCL,

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

0 Answers   Informatica,

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

For more Informatica Interview Questions Click Here
Categories