Interested to Buy Any Domain ? << Click Here >> for more details...
How to display all the duplicate records from the oracle
Table?
- 3 Answers
- 10134 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nagam
select count(*),empno from emp group by empno having count(*)>1;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the types of hashed files in data stage
What is the use of datastage director?
what is the difference between == and eq in UNIX shell scripting?
How to read multiple files using a single datastage job if files have the same metadata?
What is the difference between account and directory options ?
What are stage variables?
what is the use of materialized view?
What are the features of datastage flow designer?
Why do we use exception activity in Datastage?
What are the types of containers in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are the some differences between 7.x and 8.x version of datastage?
What is apt_config in datastage?
How to manage date conversion in Datastage?
What is aggtorec restructure operator?
