Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / m.sivakumar
The centralized in a star schema is called fact table.
fact table have two types of columns.
facts
foreign keys to dimension tables.
fact tables are three types
1)additive
2)non-additive
3)semi additive
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain scd type 3 through mapping.
What is a stored procedure transformation?
Mention some types of transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is meant by target load plan?
Why do you use Mapping Parameter and mapping variable?
On which transformations you created partitions in your project?
While migrating the data from one environment to another environment how would you manage the connections?
waht type of interface is used for testing the data in informatica
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Do you find any difficulty while working with flat files as source and target?
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
where to store informatica rejected data? How to extract the informatica rejected data?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How an expression transformation differs from aggregator transformation?
