How to load every nth row from a Flat file/ relational DB to the target? Suppose n=3, then in above condition the row numbered 3,6,9,12,.....

Solution: 1.      Drag the source to mapping and connect it to sorter transformation. 2.      Arrange the salary in descendin...

What is Business Intelligence (BI)?   Business Intelligence is a generalized term applied to a broad category of applications and t...

Data Profiling in Datawarehouse Data Profiling      A process whereby one examines the data available in an existing database an...

Change data capture System in Datawerhouse Change Data Capture (CDC) is a generic term for techniques that monitor operation...

Meta Data The ETL metadata functional element is responsible for maintaining information (metadata) about the movement and transformatio...

ETL refers to the methods involved in accessing and   manipulating source   data and loading it into target database. During the ETL pro...

Logical design in datawearhouse Logical Data Model (LDM) - A logical design is conceptual and abstract. The process of ...

Physical design in datawearhouse Physical design is the creation of the database with SQL statements. During the physical d...

1) What is Index? A pointer to data having physical representation is called as Index. Record can b...