Answer Posted / nagendra phani
Data Mart is the subset of datawahehouse and it is used to
store the data department wise.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Plz can any one say me how to get the informatica certification materials and dumps
What are the types of caches in lookup?
What do you mean by channel change?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the reusable transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is a mapplet/worklet in informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
EXL informatica Questions
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is a predefined event?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Which means the first record should come as last record and last record should come as first record and load into the target file?
