Answer Posted / sanjay
A fact which can be used across multiple datamart is called
as confirmed fact. Confirmed fact allows having the same
name in different table.
| Is This Answer Correct ? | 8 Yes | 14 No |
Post New Answer View All Answers
What are the measure objects?
How do you load first and last records into target table?
What is the need for an etl tool?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the mapping parameters and mapping variables?
difference between informatica 8.1.1 and 8.6
What is Data Caches size?
Is it possible to create multiple domains on a single Informatica server?
How to Create a folder using pmrep command?
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 are the uses of etl tools?
How can you differentiate between powercenter and power map?
permutations of mapplet