Answer Posted / jayachandra
A dimenssion which is shared by multiple fact tables is
known as "Confirmed dimenssion".
ex:customer dimenssion
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a repository? And how to add it in an informatica client?
Can you use flat files in Mapplets.
write a query to retrieve the latest records from the table sorted by version(scd)
What is aggregate cache in aggregator transformation?
What are the main features of Oracle 8i with context to datawarehouse?
How union transformation is used?
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 ?
Scheduling properties,whats the default (sequential)
What is the use of target designer?
Briefly explain the aggregator transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is persistent lookup cache?
What are the static cache and dynamic cache in informatica?
Differentiate between a repository server and a powerhouse?