Answer / segu satish

answer for 3rd question:

select * from emp where rowid =(select max(rowid) from emp)

Answer / srinu

1) using external filter we use command is sed we get
2)select * from (select rownum rno,emp.* from emp)
where rno in(5,6,7)
or
select * from (select rownum rno,emp.* from emp)
where rno between 5 and 7
or
select * from emp where rownum<8
minus
select * from emp where rownum<5
in first two are very efiiciency compare to third one
because in third iam using set operator
3)select * from emp where rowid=(select max(rowid) from emp);

Answer / reddy obul

__for 2nd question answer is:
select * from table where rowid<8 minus select * from table
where rowid<5
__for 3rd quesion answer is:
select * from emp where rowid in(select max(rowid) from emp)

Answer / sarath

for 2nd:
select * from table where rownum<8 minus select * from table where rownum<5;

Answer / ravi

1 answere : we can use @rownum =1 and reject the first record....

Answer / subbu

2nd answer:

select * from(select rowid from tablename where rowid between 5 and 7);

Answer / 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;

what is the main difference between sorragate key n primary key in one word

2 Answers  

Have you have ever worked in unix environment and why it is useful in datastage?

0 Answers  

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

0 Answers   IBM,

how to get the unique records on multiple columns by using sequential file stage only

3 Answers  

what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,

how to design the change capture stage in(data stage parallel jobs) type 2

2 Answers   IBM,

how to find out number of records imported into source file?

1 Answers  

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

2 Answers   TCS,

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

0 Answers