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

i have 2 flat files one table contains duplicates another one
no duplicates.... so i need like this i don't want
duplicates...pl's give me ans...

Question Posted / chennapanaidu

Answers were Sorted based on User's Feedback



i have 2 flat files one table contains duplicates another one no duplicates.... so i need like thi..

Answer / teja

place sorter transformation after source qualifier of duplicates flatfile and enable property distinct

Is This Answer Correct ?    5 Yes 1 No

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like thi..

Answer / guest

with the help of joiner transformation we can join these two
flat file sources and reject the duplicate rows using normal
join in joiner transformation

Is This Answer Correct ?    6 Yes 4 No

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like thi..

Answer / ankit kansal

Hi Gow,
As Question specified there are two source files so you can not user Distinct clause in Source Qualifier.

http://deepinopensource.blogspot.com/

Is This Answer Correct ?    0 Yes 1 No

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like thi..

Answer / gow

Hi Teja

We can use distinct option in source qualifier of the table having duplicate records itself right? Why do we need to use sorter after the source qualifier?.

Please correct me if i am wrong.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Informatica Interview Questions

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers   Informatica,

what is data driven?

5 Answers   TCS, Wipro,

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

Which is better performance wise database or file?How?

2 Answers   TCS,

Define mapplet?

0 Answers  

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

What is informatica? Why do we need it?

0 Answers  

What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,

For more Informatica Interview Questions Click Here
Categories