how will you get 21 to 30 record from 50 records?
- 6 Answers
- 12097 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 |
wht target override?wht advantages it has compare to target update?
Roles and Responsibilties of Informatica Production Support Member?
what is metadata?
What is the status code?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
Mention few advantages of router transformation over filter transformation.
What is an aggregator transformation?
How can u insert o ne row in the target if that row does not exists in the target and update if it exists
Enterprise data warehouse your projects phase by phase explain?
how to load duplicate row in a target
What is depict expression change?
Teradata 
