What is the difference between Junk and Confirmed Dimention?
where can be used htat one in Informatica?

Answer Posted / sarvesh

merge two or more dimensional tables which are having the
low cardinality colomns into a single table is known
as "junk dimensional tables,
two or more fcat tables can be shared with a single
dimensional table is known as "conformed dimension"

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1633


What are the new features of informatica 9.x developer?

524


What is rank transformation?

564


How union transformation is used?

579


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2052






Whats the difference between informatica powercenter server, repositoryserver and repository?

665


Suppose we do not group by on any ports of the aggregator what will be the output?

561


How to convert multiple rows to single row (multiple columns) in informatica

886


What are the different lookup cache(s)?

611


Implementation methodology

1250


what are the Methods For Creating Reusable Transformations?

640


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

685


how tokens will generate?

1722


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1117


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

622