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|
create a mapping to retrieve the employees who are getting salary greater than average salary?
What is version control in informatica ? Advance thanks
which is better perfomancewise lookup or joiner and why?can anyone give example?
explain abt ur project architecture?
Define Update Override?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
I cleared Informatica certification Designer. if anybody need dumps, can contact at firstname.lastname@example.org
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
i have two source data there is no pk,fk how to join the two sources
what is workflow varible
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?