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??
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
how many maximum session supports to multiload in teradata ??
how would u estimate the size of Aggregator transform data and index cache?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
Explain about power designer data modeling software?
what are the reports developed in sap bw project and what is the requirement for developing it?
what is Forward,Reverse and Re_engineering?
How many types of transformations supported by sorted input?
what is the use of server manager?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
Which transformation we use to convert 'NA' to 'Not Available'
What is data modeling and data mining?
What is etl process?
What are the names of the layers in etl?
What is etl tool in hadoop?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?