✍ Kashif M
Trends

Sunday, 25 August 2013


Informatica - Source Dependent Extract (SDE)


By on August 25, 2013

Source Dependent Extract (SDE)

Source Dependent Extract (SDE) mappings – extracts the data from the transactional Source Systems and loads into the data warehouse staging tables. 

SDE mappings are designed with respect to the source’s unique data model.

SDE_* workflows have only the staging table, the workflow will load the data into the staging area tables.
In the staging the tables will not have index. 

It always truncates the data and loads the data into staging table. 

So the load type will be BULK mode because the stagings have no indexes defined.

Work Architecture of SDE


In Informatica we can see the mappings with the name of SDE_*.For your Reference see the below Picture.


.

Kashif
mkashu: Informatica - Source Dependent Extract (SDE)
Review : Kashif | Kashif
Update: August 25, 2013 | Rating: 4.5

Comment for "Informatica - Source Dependent Extract (SDE)"

0 comments

Post a Comment

Blog Archive