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 will you remove the duplicate records from flat file
without using sorter?

Answer Posted / sathish

use aggregater T/R after source qualifier select all ports in group by clause it will removes the duplicates

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many number of sessions can one group in batches?

1120


In warehouses how many schemas are there?

1031


How can repository reports be accessed without sql or other transformations?

1184


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

994


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

969


Explain sessions. Explain how batches are used to combine executions?

975


What is a sequence generator transformation?

987


What are the designer tools for creating transformations?

1071


How to generate or load values in to the target table based on a column value using informatica etl tool.

1039


What is the meaning of decode in informatica?

1093


Define sessions in informatica etl?

986


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.

2160


What are the types of schemas we have in data warehouse.

924


Why do you use Mapping Parameter and mapping variable?

1709


What is workflow monitor?

1018