Interested to Buy Any Domain ? << Click Here >> for more details...
what is dimension table?
- 17 Answers
- 32768 Views
- I also Faced
- E-Mail Answers
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 we store previous session logs?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
Can we use the mapping parameters or variables created in one mapping into another mapping?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
what is the diff b/w target load plan and cbl?
Examples of Fatal & Non-Fatal error?
If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to get EVEN & ODD numbers separately?
Teradata 
