what is dimension table?
Answers were Sorted based on User's Feedback
Answer / uday
a dimension table contains descriptive attributes which are
typically textual field or numeric data that behaves as text
field
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / hidayathulla
A table which contains both current and historical data is
the dimensional table.
| Is This Answer Correct ? | 4 Yes | 6 No |
Answer / amedela chandra sekhar
Dimension table it consist master data and Non-numeric data
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / senthilkumar
Table which contains important business entities called
Dimension Table.
Dimension Tables are also called as Lookup or Reference
Table
| Is This Answer Correct ? | 5 Yes | 10 No |
Answer / giri
dimetion table is havig decriptive data about u r
bissiness, it having more no row
| Is This Answer Correct ? | 3 Yes | 10 No |
Answer / mahesh
it contains charactetistic data,with is one we can see
summarised data
for example profit fact table can see by using time dimension.
| Is This Answer Correct ? | 1 Yes | 11 No |
Answer / kunal
dimesion is nothing but structure,it contains tables and
structure
| Is This Answer Correct ? | 8 Yes | 29 No |
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
how lookup is acting as both active and passive ? how is it possitble?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
Do joiner transformation use cache? If so describe?
HOW TO YOU LOAD TIME DIMENSION
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?