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

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

1 Answers   IBM,

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

How the facts will be loaded? explain

2 Answers   HCL,

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

For more Informatica Interview Questions Click Here
Categories