how to get the unique records on multiple columns by using
sequential file stage only

Answer Posted / chandu

in sequential file there is one option is there i.e
filter.in this filter we use unix commands like what ever we
want.in this question we use uniq command in filter.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1343


Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1997


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1279


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1890


What are the primary usages of datastage tool?

856


What are stage variables and constants?

922


What is process model?

1747


What is a merge?

861


What are the various kinds of the hash file?

895


What are data elements?

874


What is the importance of the exception activity in datastage?

857


What are the types of hashed files in data stage

872


Explain datastage architecture?

1080


Give an idea of system variables.

788


Describe stream connector?

1053