Interested to Buy Any Domain ? << Click Here >> for more details...
Create a job to load all unique products in one table and the duplicate rows in to another table.
The first table should contain the following output
A
D
The second target should contain the following output
B
B
B
C
C
Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table.
The first table should contain the following output
A
B
C
D
The second table should contain the following output
B
B
C
- 3 Answers
- 10188 Views
- Deloitte, IBM, I also Faced
- E-Mail Answers
Answer Posted / nams
It can be done by unix uniq -u file_Name and uniq -d file_Name
or it can be done from datastage sequential file stage filter option from property.....write command overthere like above.....
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are transforms and what is the differenece between routines and transforms?
What a datastage macro?
How to Remove Duplicate using SQL?
Name the command line functions to import and export the DS jobs?
how many rows sorted in sort stage by default in server jobs
Explain usage analysis in datastage?
what are the errors,warnings in datastage
Nls stands for what in datastage?
What is a quality stage in datastage tool?
Explain Quality stage?
What is active and passive stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Terminate Activity
Name the third party tools that can be used in datastage?
what is the use of materialized view?
