-
Fact and dimensions
Which type of relation between fact and dimension table in star schema and snowflake schema?like one to one or many to many?
-
Star Schema Fact Tables
Is it possible that a Star Schema contains more than one fact tables? If Yes, How?
-
Source Qualifier
What is a Source Qualifier?
-
Fast Record Append
Which is the faster way - Adding a record at the beginning of a file or adding a record at the end of a file? Explain
-
Sorted Input option in Incremental Aggregation
Why should not we use sorted input option when using Incremental Aggregation?
-
-
Aggregate Value
Explain a mapping design to start aggregating the values before getting all the rows from the source.
-
Data Loading While Session Failed
If there are 10000 records and while loading, if the session fails in between, how will you load the remaining data?
-
-
-
how to join the data of two tables which does not have common columns
how to join the data of two tables which do not have common columni mean how to perform non equi join in informaticaEg:just like getting data from emp and salgrade table of oracle where sal is between losal and hisalthanksvenu
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
What is Data Transformation Manager?
After the load manager performs validations for the session, it creates the DTM process. The DTM process is the second process associated with the session run. The primary purpose of the DTM process is to create and manage threads that carry out the session tasks.· The DTM allocates process memory for the session and divide it into buffers. This is also known as buffer memory. It creates the main thread,...
-
What are Target Types on the Server?
Target Types are File, Relational and ERP.