ETL
What is the difference between a data warehouse and a data mart?
What is the difference between a data warehouse and a data mart? Here is the m…
Read more
Informatica
Retrieving first and last record from a table/file
Retrieving the first and last record from a table/file Source Table: OT_SRC_D…
Read more
Informatica
Sending Odd numbered records to one target and even numbered records to another target | How to send alternate record to target?
Sending Odd-numbered records to one target and even-numbered records to anoth…
Read more
SQL
Difference between Primary Key and Unique key
The primary key identifies each record in the table, and the unique key prevent…
Read more
Informatica
Why ETL is used?
The conventional application for Informatica is: The company uses it to tran…
Read more
Informatica
What is the need of an ETL tool?
The problem comes with traditional programming languages where you need to conn…
Read more
Informatica
What is ETL?
Extract: This is the first step in the process of the ETL process in the Inf…
Read morePopular Posts
-
Sending Odd-numbered records to one target and even-numbered records to another target OR How to send the alternate record to the target...
-
Retrieving the first and last record from a table/file Source Table: OT_SRC_DEV1.Employees . . . . . . Step 1: Drag the Source on Source ...
-
The primary key identifies each record in the table, and the unique key prevents duplicate entries in a column except for a NULL value.
Social Plugin