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

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

where is the reject loader .

1 Answers  

How can you generate reports in informatica?

0 Answers  

Scheduling properties,whats the default (sequential)

0 Answers  

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,

how to create user defined function (udf) in informatica

0 Answers   Informatica,

How are parameters defined in informatica?

3 Answers   HP, TCS,

Define maping and sessions?

3 Answers  

how may sources can be used in a mapping at a time?(limit)

6 Answers   IBM,

sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories