1) In a dataset how to delete a single row?
2) i have 50 rows , i want to display 5-7 records only?
How to write the sql query?
3)i have 40 rows,i want to display last row? write sql query?
- 7 Answers
- 17578 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ravi
1 answere : we can use @rownum =1 and reject the first record....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How to read multiple files using a single datastage job if files have the same metadata?
What are sequencers?
Is possible to create skid in dim,fact tables?
What are the some differences between 7.x and 8.x version of datastage?
What is the difference between server job and parallel jobs?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
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 repositery?
what is use of SDR function?
what is ds administrator used for?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How you can fix the truncated data error in datastage?
How can you write parallel routines in datastage PX?
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
