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

Different circumstance which drives informatica server to expel records?

0 Answers  

Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?

1 Answers   Wipro,

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

0 Answers   CTS,

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

What differs when we choose the sorted input for aggregator transformation?

0 Answers  

what is mapping performence?

2 Answers   Cap Gemini,

Tell me about Propagate functions in informatica

0 Answers  

How informatica process data means how informatica works?

2 Answers   TCS,

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,