Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8494 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
What is a mapping?
what are the reports developed in sap bw project and what is the requirement for developing it?
Give the benefits of data integration suite?
What is etl process? How many steps etl contains?
What is tracing level? How many types of transformations supported by sorted input?
what is the use of structures?how many nodes can u create in a structure?
When do we analyze the tables? How do we do it?
what is the difference between cardinality and Nullability?
SCD2 will work on only dimension tables as well as fact Table?
Explain etl?
Explain about enterprise scalability and roi of data integration suite?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What are the names of the layers in etl?
What is tracing level?
Identifying the bottlenecks in various components of Informatica and resolving them.
