Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / krishna
a dimension table contains the master data pertaining to a
subject area. this table is referenced by the fact table
when it is loaded.
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what are the Methods For Creating Reusable Transformations?
Is it possible to revert a global repository to local one and why?
Difference between Target-based loading and constraint-based loading?
What is session task and command task?
What do you mean by filter transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How can informatica be used for an organization?
How many types of sessions are there in informatica.please explain them?
What is mapplet in informatica?
What is the benefit of session partitioning?
Explain the difference between a data warehouse and a data mart?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Explain the etl program with few examples.
