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 |
What is data cleaning?
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.
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
what is session partitioning?
What are materialized views & where do we use them?
Difference between flat files and relational sources?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what is Forward,Reverse and Re_engineering?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
How we can see table structure?
what is the use of server?