Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how will you get 21 to 30 record from 50 records?

Answers were Sorted based on User's Feedback



how will you get 21 to 30 record from 50 records?..

Answer / srikanth

select * from table where rownum<=30

minus

select * from table where rownum<=21;

Is This Answer Correct ?    13 Yes 2 No

how will you get 21 to 30 record from 50 records?..

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

how will you get 21 to 30 record from 50 records?..

Answer / test

use rownum in Source Qualifier if the specified target is
an Oracle DB

Is This Answer Correct ?    6 Yes 1 No

how will you get 21 to 30 record from 50 records?..

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

how will you get 21 to 30 record from 50 records?..

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

how will you get 21 to 30 record from 50 records?..

Answer / giri

Very simple
Using sequent generator then Filter transformation

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Define Update Override?

1 Answers  


differences between service based and product based?

0 Answers   Satyam,


1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  


Design time, run time. If you don't create parameter what will happen

0 Answers  


Why do we use DSS database for OLAP tools?

2 Answers  


I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers   Syntel,


Explain constraint based loading in informatica

0 Answers   Informatica,


Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,


what are surrogate keys?

5 Answers  


What are the circumstances that infromatica server results an unreciverable session?

1 Answers  


What is the functionality of update strategy?

2 Answers  


Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,


Categories