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
- 9930 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 |
what is snow flack schema?
How do you load 10 different sources with 10 different layouts to 10 different tables?
how to transfer file from one system to another system in unix? which cmd to be use?
How many nodes supported by a one cpu in parallel jobs?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
What could be a data source system?
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
source file is having 5 records while moving into target it want to be 10 records
what is A Datastage?
What is the command line function to import and export the ds jobs?
what is use of SDR function?
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
Teradata 
