Answer Posted / mln
The fact which does not contain any facts or mesaurables.
Ex:the fact table which is used to store the students
information is he came to school or not cannot have weather
they are attending all classes.
which is a measure
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What do mean by local and global repository?
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 flashback table ? Advance thanks
what is diff b/t sorter t/r and agg have the option sorter property...
What are pre and post-session shell commands?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Whats there in global repository
In how many ways we can create ports?
explain abt ur project architecture?
Which files are created during the session rums by informatics server?
How many input parameters can exist in an unconnected lookup?
Can we override a native sql query within informatica?
How can we handle two sessions in informatica?
What are the types of data warehouses?
Describe the impact of several join conditions and join order in a joiner transformation?
