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
- 19662 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
Where the datastage stored his repository?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What are orabulk and bcp stages?
root tree will find which is server job and which is parallel job?
How can we improve performance of data stage jobs?
How do you import and export data into datastage?
How many areas for files does datastage have?
What is the difference between account and directory options ?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How to read multiple files using a single datastage job if files have the same metadata?
What is the flow of loading data into fact & dimensional tables?
Explain usage analysis in datastage?
What is the use of datastage designer?
What could be a data source system?
What is a ds designer?
