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
In informatica workflow manager, how many repositories can be created?
What is a pre-defined event and user-defined event?
What is the function of union transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to implement security measures using repository manager?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Design a mapping to load a target table with the following values from the above source?
What is parallel processing in informatica?
Can you generate sequence numbers without using the sequence generator transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the use of source qualifier?
How many numbers of sessions can one group in batches?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain how to import oracle sequence into informatica?
Explain the code page compatibility?