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...


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?

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

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,


what is surrogate id ?

3 Answers   IBM,


Which is costliest transformation? costly means occupying more memory?

3 Answers  


Explain grouped cross tab?

1 Answers   Accenture,


how many types of dimensions are available in informatica?

0 Answers  


What is workflow? What are the components of workflow manager?

0 Answers  


What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  


difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,


I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  


What is IQD file?

1 Answers  


How can we delete duplicate rows from flat files?

0 Answers  


what are 3 tech challenges/ common issues you face?

0 Answers   TCS,


Categories