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 can one eliminate dupliacte data with out using
distinct option?

Answer Posted / ankit kansal

An Alternative way
Using Rank Transformation select group by all and only select only those rows whose indexes are one.


http://deepinopensource.blogspot.in/

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the complex transformation you used in informatica

2578


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

1065


How can we improve session performance in aggregator transformation?

1093


How do you handle two sessions in Informatica

1127


Explain the types of transformations?

1050


how to load dimension table and fact table. plz tell me the steps.

2083


What is an aggregator transformation?

1084


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2117


Explain in detail about scd type 1 through mapping.

1416


What are the types of data warehouses?

1497


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2377


Differences between connected and unconnected lookup?

1201


what is SDLC way of code development?

2019


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2142


How to load a Dimension ? and how to load a fact table?

1402