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

how can u avoid duplicate rows in flat file?

Question Posted / radhakrishnansk

Answers were Sorted based on User's Feedback



how can u avoid duplicate rows in flat file?..

Answer / sunil

In a sorter transformation select distinct option to avoid
duplicates in a flat file

Is This Answer Correct ?    11 Yes 0 No

how can u avoid duplicate rows in flat file?..

Answer / radhakrishnansk

sorted transformation

Is This Answer Correct ?    6 Yes 1 No

how can u avoid duplicate rows in flat file?..

Answer / ramanaiah

without using sorter,and aggregrator transformations.we can
useing dynamic lookup to avoid duplicate rows.

Is This Answer Correct ?    3 Yes 1 No

how can u avoid duplicate rows in flat file?..

Answer / sbvp

i also faced this question . i said that i am using sorter
and agg group by options. but they ask me again with out
using sorter and agg how can u eliminate the duplicates? so
, plz give me a answer for that

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what are the types of facts with Examples?

3 Answers  

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

1 Answers   IBM,

When to use normalization transformation other than cobol source?

2 Answers  

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

How to display First letter of Names in Caps?

7 Answers  

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

0 Answers  

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories