how to get the unique records on multiple columns by using
sequential file stage only
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / todearhari
Just a small correction to Above Answer ,First we need to sort the Data then use the Uniq then only you will get Complete uniq records as uniq compares line by line.
Command:
Sort |Uniq
Is This Answer Correct ? | 2 Yes | 0 No |
how to remove duplicates in transformer stage by using stage variables?one example?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is the difference b/w Hash file and Lookup Fileset stages?
Can you highlight the main features of ibm infosphere information server?
i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com
Lookup constraints
How To find the location of APT_confid file
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
how can i abort the job if i get more than 100 errors in job log?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Can you explain how could anyone drop the index before loading the data in target in datastage?
why we use hash file for lookup?