1)How to Duplicate Records Delete in Sequential file?
- 4 Answers
- 14186 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naga
connect sequential file to dataset and use partition
technique and perform sort and select unique
| Is This Answer Correct ? | 19 Yes | 6 No |
In the sequential File stage there is a option called filter.
there we can use UNIX command.
syntax for Remove duplicate: uniq or sort -u
| Is This Answer Correct ? | 11 Yes | 1 No |
Define ds designer?
explain unit testing,systemtesting,integrated testing
What are transforms and what is the differenece between routines and transforms?
With out using Funnel Stage, how to populate the data from different sources to single target
what is 'reconsideration error' and how can i respond to this error and how to debug this
How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?
what is usage of datastage with materialized views
Difference between in process and inter process?
how to convert rows into columns
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
How did you reconcile source with target?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
Teradata 
