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
What is aggregate cache in aggregator transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is target designer and target load order?
What all join we can perform in LOOKUP transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
how tokens will generate?
How do you manage the Parameter files while migrating your data from one environment to another environment?
How to partition the Session?
Can we override a native sql query within informatica?
When do you use sql override in a lookup transformation?
How are the sources and targets definitions imported in informatica designer?
Reusable transformation and shortcut differences
What are multi-group transformations?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is joiner transformation?