we hava more than 1000 records. i have to select first 5
record, last 5 record and 5 records from middle of the source.
how can i do in oracle as well as in informetica??
- 4 Answers
- 7279 Views
- I also Faced
- E-Mail Answers
Answer Posted / chanukya
have the sequence generator transformation in the mapping
whcih will give you the row numbers.
From there you can take watever rows you want. From 1 to
last or anything.
This wil help you.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Explain and compare etl & manual development?
Is apache nifi an etl tool?
What is Data Vault???
What are cubes and olap cubes?
Can u access a repository created in previous version of Informatica?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
how would u estimate the size of Aggregator transform data and index cache?
what is the difference between cardinality and Nullability?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
What are the key benefits of ETL Testing?
Two default user groups created in the repository are____and_____.
Which transformation we use to convert 'NA' to 'Not Available'
what is granularity in Data ware House?
what are Lookup caches options? Including persistent caches.
