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
how can we create rank using datastage?what is the meaning of rank?
What is job control?
What are the functionalities of link partitioner and link collector?
What are iconv and oconv?
How the ipc stage work?
What are the various kinds of containers available in datastage?
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
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
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
Does datastage support slowly changing dimensions ?
Why fact table is in normal form?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Define ds designer?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
how to abort the job its matain duplicates?