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|
When you move from devel to prod how will you retain a variable
what is difference between dimention table and fact table?
without dynamic lookup how to insert new rows and update existing rows?
how to duplicates from expression transformation without using sorter before that
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
what is size of u r database?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
what are challenges that you faced in testing? give solution to it?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400