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 / segu satish
answer for 3rd question:
select * from emp where rowid =(select max(rowid) from emp)
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is ds designer?
What are the repository tables in datastage?
How do you import and export data into datastage?
Is the value of staging variable stored temporarily or permanently?
What are the types of views in datastage director?
If you want to use the same piece of code in different jobs, how will you achieve it?
How many types of stage?
How do you import and export the datastage jobs?
What are the functionalities of link partitioner?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the types of containers and how to create them?
How you can fix the truncated data error in datastage?
Differentiate between datastage and informatica?
What are the components of ascential data stage?