What is degenerated dimention table?

Answer Posted / chinth

A degenerared dimension is a dimension which is having one
attribute,and is placed in a fact table.

for ex: invoice no

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we can use union transformation?

612


Describe data concatenation?

576


can anyone suggest best free Talend data integration training online

1263


How can you define user defied event?

624


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1090






How do you load unique records into one target table and duplicate records into a different target table?

712


what is the hint? how to use it to reduce the query processing in program?

6324


What are pre and post-session shell commands?

745


How are indexes created after completing the load process?

989


Explain the pipeline partition with real time example?

656


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

777


Performance tuning( what you did in performance tuning)

1489


How would you join a node to the already existing domain?

683


Is there any way to read the ms excel datas directly into informatica?

552


What is the use of target designer?

610