Answer Posted / praveen kumar pendekanti
If a dimension exists in more than one fact table is known
as confirmed dimension. For every fact table confirmed
dimension should be there ex:: Time dimension....
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
Where are the source flat files kept before running the session?
What is the difference between a repository server and a powerhouse?
What is an aggregator transformation?
What are the differences between joiner transformation and source qualifier transformation?
How do you migrate data from one environment to another?
What are the types of schemas we have in data warehouse.
Global and Local shortcuts. Advantages.
What are the informatica performance improvement tips
tell me about your project functionality
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
Tell me about Propagate functions in informatica
what are the deliverables?in your project?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
permutations of mapplet
What is the Process to creating lookup transformation in informatica