Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 20147 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ritesh chatterjee
Answer to Qust 1
Sed 1d "Dataset Name" from unix by this way you can delete
1st record from dataset,in place of 1 you can place any number.
Answer to Question 2
select * from tablename
where rowid between 2 and 7;
Answer to 3rd qus:-
select * from tablename
where rownum = 40;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to read multiple files using a single datastage job if files have the same metadata?
What are the differences between datastage and informatica?
What are iconv and oconv?
Where do you see different stages in the designer?
options available in sequence job to run,validate?
How to perform incremental load in datastage?
AGGREGATOR default datatype
Can we use target hash file as a lookup ?
Explain the situation where you have applied SCD in your project?
How do you import and export data into datastage?
What are the partitioning techniques available in link partitioner?
What are the repository tables in datastage?
How do y read Sequential file from job control?
how to abort the job its matain duplicates?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
