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
How can we improve session performance in aggregator transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
What is resilience time?
Explian the Process of deployment groups in informatica
What is a connected transformation?
Write the different tools in the workflow manager?
Which development components of informatica have the highest usage?
What if the source is a flat-file?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is native users?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the informatica performance improvement tips
what is the difference between informatica6.1 and infomatica7.1
What are the issues you have faced in your project? How did you overcome those issues?
What are the designer tools for creating transformations?
