Answers were Sorted based on User's Feedback
Answer / usha
the dimension which is located in a fact table is know
|Is This Answer Correct ?||4 Yes||0 No|
Answer / renu
the dimension which has no dimension table of its own and is
derived from the fact table.
|Is This Answer Correct ?||2 Yes||0 No|
Answer / babu
A DIMENSION WHICH IS GENERATED BY AT RUN TIME IS CALLED AS
|Is This Answer Correct ?||2 Yes||1 No|
Answer / prathap kumar chenna
a fact which contain key/value and which does not supports
Ex: poly numbers %
invoice numbers .....
|Is This Answer Correct ?||0 Yes||0 No|
Answer / gangadhar
Degenerated dimension means which derived from fact table and which does not have its own dimension table
Ex: Invoice Number
|Is This Answer Correct ?||1 Yes||2 No|
Answer / lokesh
in degenerative dimension all are factfactless that meons
only primarykeys will present
correct me if it is wrong
|Is This Answer Correct ?||0 Yes||2 No|
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
what is degenerated dimension table with scenario
plz plz plz send client names and project names in informatica?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
Difference Between ETL & ELT?
Can i create a lookup table without cache.
What is a look up function? What is default transformation for the look up function?
What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).
Diff b/w ShortCut and reusabel Object ?
what is the complex transformation you used in informatica
What are active transformations? Name them.