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...

how do u fnd the duplicate rows and how to delete the
duplicate rows?

Answer Posted / sankar

repet(more then one time) the rows is duplicate rows,
there r many ways to dele the duplicate rows
1.in source qualifies t/r select the DISTINC option
2.in aggreter t/r select the group by port
3.in sorter t/r select the distinc

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a router transformation?

1047


What is a passive transformation?

1037


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1022


What is meant by active and passive transformation?

1031


How to create Target definition for flat files?

1157


What is informatica? Why do we need it?

1038


What is the use of source qualifier?

1070


What is a node in Informatica?

1002


What is sorter transformation?

976


What is rank transformation in informatica

1108


What are the different versions of informatica?

1183


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2139


What is session task and command task?

1176


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1585


What is meant by a domain?

1078