Slowly Changing Dimension Type 2 Illustration Using Informatica - By Mohan Vamsi Pentakota

SCD Type 2 Illustration Using Informatica - By Mohan Vamsi Pentakota (Slowly Changing Dimension Type 2)

Category:

Education

Tags:

• SCD Type 2
• Informatica
• Mohan Vamsi Pentakota
• Datawarehousing
• Business Intelligence
• SQL Server
• Oracle
• Database
• SQL
• Microstrategy
• Cognos
• BO
• MySQL
• Teradata
• Talend
• Slowly Changing Dimensions

[muzaffer1424]

Hi..nice job. can you also please demonstrate a constraint based loading..can u create a mapping to load data from flat_file to multiple colums of diffrent tables in database which are keys in other tables.? that will be a great help.

[pmvrss]

@muzaffer1424 Thanks for the appreciation. Yes you can load data from a flat file source into different tables.

[muzaffer1424]

@pmvrss I have couple issues needed to be taken care of...is there any possible way i can contact you?

[pmvrss]

@muzaffer1424 Yes , you can send me an email at vamsi27@gmail.com or you can leave me message on my twitter page.

[vrupatel]

Hi Vamsi thanks for such a simple and detail explanation. I though have one question. The targets in this mapping are three different tables, so does data resides and reflects in one table?

[pmvrss]

@vrupatel Even though the mapping is showing three different table names, All the three informatica level table names point to the same target table (I mean back end database table).

[ashshbharti]

Its really a useful video, please share some information how to import sap bapi/rfc using Transformation and write to the target like in database.

[lifevaidya]

Really cool stuff!!

[saimtek1]

Very informative video, thanks for uploading.

I just want t o know how data is going in one target table when we have three different target table on mapping level.

[pmvrss]

Follow me on Twitter: vam_27