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
What is meant by incremental load?
Can we create Hierarchies in generic datasources?
what is the difference steps for data modeling?
What is the difference between round-robin partitioning and hash partitioning?
what is the difference between cardinality and Nullability?
Explain do we need an etl tool? When do we go for the tools in the market?
if i have a query as flat file how can we load data to target table
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
Explain me ETL project architecture in Detail?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
Explain what are the various etl tools in the market?
Do we need an etl tool?
when will use SQL override in a lookup transformation?
what is session partitioning?