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

What is difference between a gateway node and worker node?

0 Answers  

tell me about your project functionality

0 Answers  

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

how can u tune u r informatica mapppings

2 Answers   CTS,

What is source qualifier transformation in informatica?

0 Answers  

How informatica process data means how informatica works?

2 Answers   TCS,

what is distinct

4 Answers  

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

What is Cognos script editor?

0 Answers   Cognizant,

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,

For more Informatica Interview Questions Click Here
Categories