Answer Posted / parthasarathi swain
A Dimension table is a table that contains detailed and
consistent data ie those data that are not frequently
changing in the other words we can say those as master data.
We use the primary key of the dimensional table as the
foreign key in the fact table. For one fact table we can
have more than one dimensional table.
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
what is $$$$?
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Where is metadata stored?
What is informatica? Why do we need it?
What is a joiner transformation and why it is an active one?
Make a note of the quantity vaults made in informatica?
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
What is a repository? And how to add it in an informatica client?
What is confirmed fact in dataware housing?
What if the source is a flat-file?
How to do unit testing in informatica? How to load data in informatica ?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
how to load rows into fact table in data warehouse