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 we eliminate duplicate records in a flat file without using Sorter and Aggregator?

Answer Posted / joe

Option 1: using Unix for flat files

Option2: Using Checksum function in the expression to
generate a unique hexadecimal code for each record.
and comparing the same with the next record.

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between a repository server and a powerhouse?

1118


What is data transformation manager process?

1158


Parameter and variable differences

2063


Write the advantages of partitioning a session?

1282


What are the static cache and dynamic cache in informatica?

1192


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

1076


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1040


write a query to retrieve the latest records from the table sorted by version(scd)

1068


How to update source definition?

1088


If informatica has its scheduler why using third party scheduler?

1268


How to load the data from people soft hrm to people soft erm using informatica?

1020


wf dont have integration severances how you can run?

1938


explan ur project architecture?

2070


Explain in detail scd type 2 through mapping.

1041


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2060