Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 19958 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ritesh chatterjee
Answer to Qust 1
Sed 1d "Dataset Name" from unix by this way you can delete
1st record from dataset,in place of 1 you can place any number.
Answer to Question 2
select * from tablename
where rowid between 2 and 7;
Answer to 3rd qus:-
select * from tablename
where rownum = 40;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
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?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are some prerequisites for datastage?
What are the types of jobs we have in datastage?
Explain Quality stage?
What is the difference between datastage and informatica?
What is a merge?
What are transforms and what is the differenece between routines and transforms?
Name the different sorting methods in datastage.
What is ibm datastage flow designer?
Name the command line functions to import and export the DS jobs?
How rejected rows are managed in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
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.
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
