override source qualifier select * from tablename where rownum=1 and row

in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?

Question Posted / anoymous

Answer Posted / anoymous

override source qualifier

select * from tablename where rownum=1 and rownum=10;

Is This Answer Correct ?

4 Yes

16 No

Please Help Members By Posting Answers For Below Questions

Quickly characterize reusable change?

1127

Can we create two repositories on same database instance in oracle?

1103

How to create Target definition for flat files?

1235

How do you manage the Parameter files while migrating your data from one environment to another environment?

1033

How can we use mapping variables in informatica? Where do we use them?

1208

What is meant by incremental aggregation?

1111

What are the new features of Power Center 5.0?

1785

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2175

What is the different lookup cache(s)?

1093

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2078

What are the components of the workflow manager?

1139

Write the different tools in the workflow manager?

1072

Explain the shared cache and re-cache?

1124

what is the -ve test case in your project.

2412

Is it possible to create multiple domains on a single Informatica server?

1248