What is the difference between Power Centre and Power Mart?
Answer Posted / mubbasir
Informatica PowerCenter - has all options, including
distributed metadata, ability to organize repositories into
a data mart domain and share metadata accross
repositories,Partioning is available.
Informatica PowerMart - a limited license (all features
except distributed metadata and multiple registered
servers). No Partioning is available.
Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
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 fact table? Explain the different kinds of facts.
How can you define user defied event?
What are pre and post-session shell commands?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is the benefit of session partitioning?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the sql query overwrite in source qualifier in informatica
design of staging area?
Explain scd type 3 through mapping.
What is powercenter on grid?
Difference between Data and Index Caches?
Explain what are the different types of transformation available in informatica.
How to generate or load values in to the target table based on a column value using informatica etl tool.