Answer / srikanth

select * from table where rownum<=30

minus

select * from table where rownum<=21;

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.

Answer / test

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

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.

Answer / koti

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

Answer / giri

Very simple
Using sequent generator then Filter transformation

Define Update Override?

1 Answers  

differences between service based and product based?

0 Answers   Satyam,

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  

Design time, run time. If you don't create parameter what will happen

0 Answers  

Why do we use DSS database for OLAP tools?

2 Answers  

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,

Explain constraint based loading in informatica

0 Answers   Informatica,

Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,

what are surrogate keys?

5 Answers  

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

What is the functionality of update strategy?

2 Answers  

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,