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

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6194


How can a transformation be made reusable?

1174


How do you update the records with or without using update strategy?

1121


Is it possible to revert a global repository to local one and why?

1086


What is an expression transformation?

1024


Differentiate between joiner and lookup transformation?

1105


How do you migrate data from one environment to another?

1100


what are factless facts? And in which scenario will you use such kinds of fact tables.

1812


Differentiate between reusable transformation and mapplet.

1102


Differentiate between source qualifier and filter transformation?

1584


Is there any way to read the ms excel datas directly into informatica?

1026


What are the types of schemas we have in data warehouse and what are the difference between them?

946


Explain about Informatica server process that how it works relates to mapping variables?

1089


What is an aggregator transformation?

1101


In how many ways we can create ports?

1127