how will you get 21 to 30 record from 50 records?

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

Question Posted / kumar

6 Answers
11776 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how will you get 21 to 30 record from 50 records?..

Answer / srikanth

select * from table where rownum<=30

minus

select * from table where rownum<=21;

Is This Answer Correct ?

13 Yes

2 No

how will you get 21 to 30 record from 50 records?..

Answer / nilesh

Other than the above ans:

Using sequence generator, expression and filter
transformation
OR

Using mapping variable initialised to zero, expression and
filter transformation.

Is This Answer Correct ?

8 Yes

0 No

how will you get 21 to 30 record from 50 records?..

Answer / test

use rownum in Source Qualifier if the specified target is
an Oracle DB

Is This Answer Correct ?

6 Yes

1 No

how will you get 21 to 30 record from 50 records?..

Answer / rkumar.etl

if you want to process using unix/linux...we can use head
and tail logic to get the records from 21 to 30.

and in informatica we can use rank transformation twice to
get the required results.

Is This Answer Correct ?

2 Yes

0 No

how will you get 21 to 30 record from 50 records?..

Answer / koti

sq generator, filter transformations. write the condition
in filter transformation as select columns from table where
sno>21 and sno<30...

Is This Answer Correct ?

2 Yes

1 No

how will you get 21 to 30 record from 50 records?..

Answer / giri

Very simple
Using sequent generator then Filter transformation

Is This Answer Correct ?

1 Yes

2 No

Post New Answer