Whatis the difference between View and Materialized View ?
- 11 Answers
- 53105 Views
- Satyam, Syntel, I also Faced
- E-Mail Answers
Answer Posted / the tiklu
Materialized View is for Consumerist es, while Views
are for great men and sexy women.
| Is This Answer Correct ? | 7 Yes | 46 No |
Post New Answer View All Answers
How can informatica be used for an organization?
What is aggregate cache in aggregator transformation?
How does a rank transform differ from aggregator transform functions max and min?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Performance tuning in UNIX for informatica mappings?
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 prerequisite tasks to achieve the session partition?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is complex mapping?
How to partition the Session?
have u done any performance tuning? how u ll do?
What is rank transformation?
What is meant by lookup transformation?
Why filter transformation is an active one?
What is the commit type if you have a transaction control transformation in the mapping?
