how do u set the size of block buffer?
Answer / 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 |
How to fine tune mappings?
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?
Can u access a repository created in previous version of Informatica?
what are the reporting tools and difference between them?
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What are the names of the layers in etl?
What are the various tools used in etl?
What is virtual Data Warehousing?
what is pmrep command?
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.
Explain what are the various etl tools in the market?