Answer Posted / sarvesh
go to edit properties in any of the following trans like
rank,lookup,joiner,aggregator,there u can change the size
of buffer,but by dewfault it is 64kb.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In Which Transformation We Can Use Having Clause In Informatica?
what are the facilities provided by data warehouse to analytical users?
What is partitioning? Explain about round-robin, hash partitioning.
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Explain about hash partitioning?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Explain etl mapping sheets?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
What is full load & incremental or refresh load?
Define Dynamic push down optmization?
what is the difference steps for data modeling?
how would u estimate the size of Lookup transform data and index cache?
how does the server recongnise the source and target databases.Elaborate on this
What is a lookup table in etl?