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 |
Which will beter perform IIf or decode?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the term PIPELINE in informatica ?
what are the Methods For Creating Reusable Transformations?
How to join three sources using joiner? Explain though mapping flow.
How can you display only hidden files in UNIX
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
Differentiate between mapping parameter and mapping variable?
How can you differentiate between powercenter and power map?
How is Data Models Used in Practice?
What are the types of metadata that stores in repository?