what is a junk dimension ?
Answer Posted / mohan
junk dimention is a dimention table which holds only flags
or status where dimension field values are like True/False,
open/Close,complete/incomplete/inprogress, etc.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to call shell scripts from informatica?
how we can load rejected record's at run time?(not through bad files)
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain scd type 3 through mapping.
What is the need of an ETL tool?
How to load a Dimension ? and how to load a fact table?
where to store informatica rejected data? How to extract the informatica rejected data?
How do you load unique records into one target table and duplicate records into a different target table?
What is union transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How can you validate all mappings in the repository simultaneously?
What are the static cache and dynamic cache in informatica?
Differentiate between joiner and lookup transformation?
What is the meaning of up gradation of repository?