Download
your turn hear
Popular Posts
-
I have the source table is Number 1 1 2 3 3 4 Target_unique Target_Duplicates 2 ... -
Object Type Syntax Folder XXX_ Mapping m_fXY_ZZZ_ _x.x Session s_fXY_ZZZ_ _x.x Batch b_ Source Definition Target Definition Aggreg...
-
Factless fact table captures the many-to-many relationships between dimensions, but contains no numeric or textual facts. They are often u...
-
seq_DIM_PRODUCT Source Qualifier Transformation ‘sq_’+ table name If the source qualifier is defined ... -
1 . Bitmap indexes are most appropriate for columns having low distinct values—such as GENDER, MARITAL_STATUS, and RELATION. This ass...
-
An accumulating fact table is where all of the dimensional attributes are not available at the time of creation and the dimensions that are...
-
A code page contains the encoding to specify characters in a set of one or more languages. An encoding is the assignment of a number to a c...
-
There is a source table containing 2 columns Col1 and Col2 with data as follows: Col1 Col2 a l b p a m a n b q x y Design ...
-
Joiner Lookup In joiner on multiple matches it will return all matching records. In lookup it will return ei...
-
If query taking long time then First will run the query in Explain Plan, The explain plan process stores data in the PLAN_TABLE. it will ...
