What is aggregate cache in aggregator transforamtion?
Answer Posted / ravi sadanand
It is place where all the rows entering the Aggregator
Transformation will be placed till the aggregate
calculations like sum,Avg are made.
all the group information will be stored in index files and
row data in data cache.
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
lookup transformation with screenshots
What is meant by lookup transformation? Explain the types of lookup transformation?
On which transformations you created partitions in your project?
Have you worked with/created Parameter file
How are indexes created after completing the load process?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to handle decimal places while importing a flatfile into informatica?
how to load rows into fact table in data warehouse
What is status code in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is a snowflake schema?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
complex mapping ur project u r invlve can u explain and give real time example give me ?
What differs when we choose the sorted input for aggregator transformation?