how will you get 21 to 30 record from 50 records?
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 |
What is the different lookup cache(s)?
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
Difference between Data and Index Caches?
What is different between informatica version 8 and 9 version
How will you update the row without using update statergy?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
What is a shortcut and copy in Informatica and how two are different with each other?
How to load duplicate records in to a target table which has a primary key?
what is left outer join?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
Howmany ways yoU can update a relational source defintion and what are they?