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
On which interface you will be working as a developer?
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
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How to read the length of word in unix?
What is active and passive stage?
what is the use of surogate key in datastage
What is the method of removing duplicates, without the remove duplicate stage?
What are the stages in datastage?
Explain datastage architecture?
How do you import and export the datastage jobs?
What is the use of datastage director?
Difference between in process and inter process?
How many types of views are there in a datastage director?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How to clean the datastage repository?