What are partitions in informatica and which one is used
for better performance?
- 2 Answers
- 15391 Views
- I also Faced
- E-Mail Answers
Answer Posted / sri
Round robin
Data base
Hash key
Pass through
Key range
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
What are active transformations.
How do you change a non-reusable transformation to reusable transformation?
what are the Methods For Creating Reusable Transformations?
What do you mean by filter transformation?
How does a rank transform differ from aggregator transform functions max and min?
What is informatica? Why do we need it?
Explain lookup transformation source types in informatica
What is powercenter on grid?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How might you approve all mappings in the archive all the while?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is main use of mapplet?
Reusable transformation and shortcut differences
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to open an older version of an object in the workspace?
