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|
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is the diff b/w union and joiner and lookup?
What is diff joiner and lookup
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
how will you get 21 to 30 record from 50 records?
How to delete the (flat file) data in the target table after loaded.
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?