Interested to Buy Any Domain ? << Click Here >> for more details...
how will you get 21 to 30 record from 50 records?
- 6 Answers
- 11944 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srikanth
select * from table where rownum<=30
minus
select * from table where rownum<=21;
| Is This Answer Correct ? | 13 Yes | 2 No |
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 |
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 |
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 |
Answer / giri
Very simple
Using sequent generator then Filter transformation
| Is This Answer Correct ? | 1 Yes | 2 No |
How many number of sessions that u can create in a batch?
How to retrieve last two days updated records?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Differentiate between source qualifier and filter transformation?
What is decode in informatica?
what is the command to get the list of files in a directory in unix?
What is informatica metadata and where is it stored?
Hi experts, can anyone tell how much we use plsql in real time
Please let me know how to make Data masking in informatica..
What is powercenter on grid?
what are the difference between Informatica 7.1 and 8.1?
What are active and passive transformations?
Teradata 
