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?
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 the difference between hashfile and sequential file?
Define oconv () and iconv () functions in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
How rejected rows are managed in datastage?
On which Dimension Table you implemented SCD Type in your Project
Whats difference betweeen operational data stage (ods) and data warehouse?
What are datastage sequences?
What is use Array size in datastage
Describe the architecture of datastage?
What are transforms and what is the differenece between routines and transforms?
What is the difference between Datastage 7.5 and 7.0?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
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?
What are the various kinds of containers available in datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.