Answer Posted / shyam
Dimension table contains the textual information to analyse
the business. It contains more number of column as compare
the less no. of rows.
There are the four types of dimention table in the
Datawarehousing.
1. Confirmed Dimension
2. Shared Dimension
3. Degenerated Dimension
4. Jun Dimension.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the reusable transformations?
what are the Methods For Creating Reusable Transformations?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is union transformation in informatica?
Write the different tools in the workflow manager?
How to improve the performance of a session using sorter transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
expain about the tune parameters?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Define update strategy?
What is the difference between informatica 7.0 and 8.0?
Describe the impact of several join conditions and join order in a joiner transformation?
How do we call shell scripts from informatica?
Is there any target staging area in informatica not staging area
if we have a delimiters at unwanted places in a flat file how can we over come those.