Interested to Buy Any Domain ? << Click Here >> for more details...
how will you get 21 to 30 record from 50 records?
- 6 Answers
- 11787 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 |
Which transformation should we use to normalise the COBOL and relational sources?
What are the different clients of powercenter?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
what is the main advantage of unconnected lookup
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
What are the data movement modes in informatcia?
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
waht type of interface is used for testing the data in informatica
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
What are the performance considerations when working with aggregator transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Teradata 
