Interested to Buy Any Domain ? << Click Here >> for more details...
how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
- 1 Answers
- 3633 Views
- I also Faced
- E-Mail Answers
Answer Posted / tcs
There is no particular rule that says that mapping has to be
partitioned.But we can do so to improve the performence.Yes,it
depends on the machine configuration, as it uses the system
memory to run those sessions
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the ETL Testing Operations?
Explain different types of partitioning?
When do we analyze the tables?
Explain do we need an etl tool?
SCD2 will work on only dimension tables as well as fact Table?
What are the different Lookup methods used in Informatica?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
how would u estimate the size of Lookup transform data and index cache?
what are Lookup caches options? Including persistent caches.
What are materialized views & where do we use them?
Difference between flat files and relational sources?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is pmrep command?
What is partitioning? Explain about round-robin, hash partitioning.
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
