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
|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 / senthilkumar
Table which contains important business entities called
Dimension Tables are also called as Lookup or Reference
|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
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
|Is This Answer Correct ?||8 Yes||29 No|
what is a time dimension? give an example?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
where to store informatica rejected data?
what are types of dimentions?
can we load the data with out a primary key of a table? what is target plan?
What are the types of error logs available in Informatica?
Target increases every day even though no new record was inserted
what is the difference between mapplet & stored procedure?
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
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)
What is workflow monitor?
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?