if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
Answer Posted / vaibhav bhandeo
This technique is used when you want a performnce boost.
There will be an aggrigator cache created and will be
indexed. Although you have not given a sorted input it will
still work fine as it is indexed in cache. Please note this
is not like a page fault where you have to bring the page
from the secondary memory when not found in primary memory.
| Is This Answer Correct ? | 1 Yes | 9 No |
Post New Answer View All Answers
Explain what are the different versions of informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How to improve the performance of a session using sorter transformation?
What are the tasks that can be performed using sq?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How big was your fact table
Sequence generator, when you move from develoment to production how will you reset
What is meant by active and passive transformation?
What do you mean by filter transformation?
Explain the code page compatibility?
Explain the tuning lookup transformation - informatica