Answer Posted / chinmay
Junk dimesnion is aimension table consisting attributes
that do no belong to any fact table or any form of existing
dimesnion .
Usually it is used to hold indicator yes/no , true/false.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
What is meant by active and passive transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain the use of aggregator cache file?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Is there any target staging area in informatica not staging area
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is a joiner transformation and why it is an active one?
How to elaborate powercenter integration service?
How to load data in informatica ?
generate date / time dimension in informatica
What does update strategy mean, and what are the different option of it?
Design time, run time. If you don't create parameter what will happen
What is expression transformation?
What is standalone command task?