Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is dimension table?

Answers were Sorted based on User's Feedback



what is dimension table?..

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

what is dimension table?..

Answer / hidayathulla

A table which contains both current and historical data is
the dimensional table.

Is This Answer Correct ?    4 Yes 6 No

what is dimension table?..

Answer / amedela chandra sekhar

Dimension table it consist master data and Non-numeric data

Is This Answer Correct ?    1 Yes 3 No

what is dimension table?..

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

what is dimension table?..

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

what is dimension table?..

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

what is dimension table?..

Answer / kunal

dimesion is nothing but structure,it contains tables and
structure

Is This Answer Correct ?    8 Yes 29 No

Post New Answer



More Informatica Interview Questions

what is a time dimension? give an example?

2 Answers   IBM,


Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??

4 Answers  


where to store informatica rejected data?

0 Answers  


what are types of dimentions?

3 Answers  


can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,






What are the types of error logs available in Informatica?

1 Answers  


Target increases every day even though no new record was inserted

0 Answers   Accenture,


what is the difference between mapplet & stored procedure?

1 Answers  


I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,


if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,


What is workflow monitor?

0 Answers  


In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,






Categories