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

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

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,

Does an informatica transformation support only aggregate expressions?

0 Answers  

version controlling in informatica?

3 Answers  

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?

1 Answers  

in static and dynamic which one is better

2 Answers  

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

Have you worked with/created Parameter file

0 Answers  

Describe an informatica powercenter?

0 Answers  

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

For more Informatica Interview Questions Click Here
Categories