Hi This is Vijay,

How can your remove the duplicates in sequential File?

Answer Posted / chowdary

in sequntial file options filter--> sort | uniq -d
this will give best performence to remove duplicates.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe routines in datastage? Enlist various types of routines.

579


What are the types of containers and how to create them?

556


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1133


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

953


What is the difference between hashfile and sequential file?

716






How to read the length of word in unix?

882


Explain the importance of surrogate key in data warehousing?

706


Explain connectivity between datastage with datasources?

595


How a routine is called in datastage job?

603


What are the different kinds of views available in a datastage director?

600


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4558


Explain the datastage parallel extender (px) or enterprise edition (ee)?

725


On which interface you will be working as a developer?

633


Is the value of staging variable stored temporarily or permanently?

573


what is flow of project?

1557