Interested to Buy Any Domain ? << Click Here >> for more details...
how will you get 21 to 30 record from 50 records?
- 6 Answers
- 11603 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 |
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
How You Pull the records on daily basis into your ETL Server.
What are the prerequisite tasks to achieve the session partition?
What is the difference between lookup override and souce qualifier override ?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?
Teradata 
