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
- 7930 Views
- I also Faced
- E-Mail Answers
Answer Posted / akash
For implementation through Oracle:
Sort ASC/DESC on rowid in a sub-query and take first 5 rows
of this query in main query.
For implementation through informatica:
1. Use Rank Transformation.
2. Use Sorter Transformation.
The above are for first or last 5 records. Middle 5 records
are not included here.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is fact? What are the types of facts?
What is partitioning? Explain about round-robin, hash partitioning.
How many steps etl contains explain with example?
Explain different types of partitioning?
What is lookup table in etl testing?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
flat filevalidation in informatica
Explain the key challenges that you face while performing etl testing.
What is grain of fact?
can be used COM component in Informatica ?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What are snapshots?
Explain the difference between etl tool and olap tools?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
