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
- 19880 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / reddy obul
__for 2nd question answer is:
select * from table where rowid<8 minus select * from table
where rowid<5
__for 3rd quesion answer is:
select * from emp where rowid in(select max(rowid) from emp)
| Is This Answer Correct ? | 9 Yes | 9 No |
Post New Answer View All Answers
How to perform incremental load in datastage?
Have you used Unstructured data?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Define Job control?
How do you import and export the datastage jobs?
What could be a data source system?
What is datastage engine?
Can you explain players in datastage?
State the difference between an operational datastage and a data warehouse?
How many types of views are there in a datastage director?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
what is the use of materialized view?
What are iconv and oconv?
What are the functionalities of link collector?
