how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
Answer / 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 |
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
Explain the use lookup tables and Aggregate tables?
What is abap? What are idocs?
SCD2 will work on only dimension tables as well as fact Table?
how do u implement scheduling in Informatica?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
Can u access a repository created in previous version of Informatica?
Need Informatica Power Center 9.1 free download(for all windows version)
working of line item dimension......pls,tell overall flow
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
What is partitioning? Explain about round-robin, hash partitioning.