Interested to Buy Any Domain ? << Click Here >> for more details...
what is the logic will you implement to load data into a
fact table from n dimension tables?
- 4 Answers
- 19816 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / elango
fact table should contain all foreign key (PK) of the
dimensional tables, and it should be measured based on the
measures in the fact table as per the client specification.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to elaborate tracing level?
How can we create index after completion of load process?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Could you explain what is enterprise data warehouse?
Explain the etl program with few examples.
Explain the different kinds of facts.
How to use procedural logic inside infromatica?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
How do you load only null records into target?
How can we delete duplicate rows from flat files?
Where do we use mapping variables in informatica?
How to update or delete the rows in a target, which do not have key fields?
What is the maplet?
What is dynamic cache?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
