Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the unique records on multiple columns by using
sequential file stage only
- 3 Answers
- 10261 Views
- I also Faced
- E-Mail Answers
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 |
convert yyyy mm dd to dd mm yyyy?
how does work server jobs?
1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
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
What is apt_config in datastage?
what is the main difference between sorragate key n primary key in one word
What are stage variables and constants?
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
What could be a data source system?
What is the difference between the local container and shared container?
Triggers,VIEW,Procedures
Teradata 
