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
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
What are the new features of informatica 9.x developer?
What is rank transformation?
How union transformation is used?
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
Whats the difference between informatica powercenter server, repositoryserver and repository?
Suppose we do not group by on any ports of the aggregator what will be the output?
How to convert multiple rows to single row (multiple columns) in informatica
What are the different lookup cache(s)?
Implementation methodology
what are the Methods For Creating Reusable Transformations?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
how tokens will generate?
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
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.