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...

Hi This is Vijay,

How can your remove the duplicates in sequential File?

Answer Posted / arun

Sort the incoming data using a sort stage & use remove
duplicates on the key columns. This will remove the
duplicates in ur source file.

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you write parallel routines in datastage PX?

1067


What is usage analysis in datastage?

1363


State the difference between an operational datastage and a data warehouse?

1183


Can you implement SCD2 using join, transformer and funnel stage?

1606


If you want to use the same piece of code in different jobs, how will you achieve it?

1218


What are the functionalities of link partitioner and link collector?

1063


What are iconv and oconv?

1301


sed,awk,head

1504


What is the difference between datastage and informatica?

1185


how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

970


What is orabulk stage?

1105


What is the difference between in process and inter process?

1203


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1432


Explain Quality stage?

1210


Can you filter data in hashed file?

3827