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 / prabha kamaraj

Using Group by command removes all duplicates records in a
table

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

963


Sequence generator, when you move from develoment to production how will you reset

2025


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1939


During the running session, output files are created by informatica server. Enlist few of them.

974


What is joiner change?

1142


Differentiate between a database and data warehouse?

1139


How identifying bottlenecks in various components of informatica and resolving them?

1119


How to generate sequence numbers without using the sequence generator transformation?

1199


Explain pmcmd command usage in informatica

1121


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2173


How to generate sequence numbers using expression transformation?

1082


EXL informatica Questions

1382


Can we change Dynamic to Static or Persistent cache? If so what happens?

2200


Differentiate between reusable transformation and mapplet.

1084


What does role playing dimension mean?

1042