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
What is datastage engine?
What are the stages in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Can you explain repository tables in datastage?
How to find value from a column in a dataset?
How a source file is populated?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
which r the connectors used in san?
how to write server Routine coding?
Which algorithm you used for your hashfile?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
in oracle target stage when we use load option and when we use upsert option?
How to convert RGB Value to Hexadecimal values in datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.