#Informatica

best informatica training
etl informatica training
free informatica training
free informatica training material
free informatica training online
free online informatica training
informatica 8.6 e learning
informatica 8.6 training course
informatica 8.6 tutorials
informatica 9 course
informatica 9 e learning
informatica 9 free training
informatica 9 online training
informatica administrator training
informatica classes
Informatica complete videos
INFORMATICA corporate training
informatica course
informatica course in bangalore
informatica course in hyderabad
informatica data quality online training
informatica data transformation e learning
informatica data transformation training
informatica data transformation training course
informatica data transformation tutorials
informatica demo classes
informatica demo session
informatica developer training
informatica etl training
informatica it training
informatica learning material
informatica live demo
informatica live training
Informatica live videos
informatica materials
informatica mdm training
informatica online course
informatica online training hyderabad
INFORMATICA online training in hyderabad
informatica online training india
Informatica Online Training Part1
informatica online training usa
informatica online training videos
informatica online tutorial
informatica power center training
informatica power exchange training
informatica powercenter course
informatica powercenter e learning
informatica powercenter online training
informatica powercenter training
informatica powercenter training course
informatica powercenter training materials
informatica powercenter training videos
informatica powercenter tutorials
informatica project training
informatica training bangalore
informatica training chennai
Informatica training course
informatica training courses
informatica training dallas
informatica training for beginners
INFORMATICA training in ameerpet
INFORMATICA training in bangalore
informatica training in chicago
informatica training in hyderabad
informatica training in india
informatica training in nj
informatica training in toronto
Informatica training in USA
informatica training india
informatica training institute
informatica training materials
informatica training tutorials
informatica training videos
informatica tutorial for beginners
informatica tutorial videos
Informatica Tutorials
informatica tutorials online
informatica video training
informatica video tutorial
Informatica video Tutorials
informatica videos
informatica workflow manager
informatica xml transformation
learn informatica 8.6
learn informatica 9
learn informatica data transfomation
learn informatica online
learn informatica online free
learn informatica powercenter
learning informatica
online Data warehouse ETL training
Online Informatica training
online training for informatica
online training informatica
power center informatica tutorial

[@mynamefootball]

Beautifully explained .
Thanks!!

[@hari1445]

U r really so cool, ur explanation is so good.

[@lalatenduswain8229]

Thanks, I learn a lot from these videos.

[@ovibala5250]

Great Mam.. Many Thanks!!!

[@sreelatha5292]

Thanks a lot.Good explanation Can you post all transformation videos.

[@devexpost8508]

In Short: (Kimball) Slowly Changing Dimensions (SCDs)….
Type 1: “Overwrite” - If no existing row, add the new row. If there is an existing row, overwrite the old data in the existing row. No “history” is created for Type 1 SCD. Somewhat easier to maintain however.
Type 2: “Add new row” - Create a new row with a new key, an updated attribute, and an indication (effective dates/flag) that this is now the current row. Update the previously-current row (if one exists) to indicate that it is no longer current (end date/flag). Unlimited history, but more dimension growth.
Type 3: “Add new attribute” - Use an additional column to hold both a current and a previous value in the row. If no existing row, add the new row. If there is an existing row, move the “current” value to “previous” value, and overwrite the old current value attribute with the update. Limited history.
Note that each attribute in a row can have a different SCD Type. A single Dimension could use all three SCD types.

[@alibeli4917]

Thanx a lot

[@mrreddy6]

very useful info

[@creatorlikepro]

Madam u skiped explain unconnected lookup did u explain in any other video madam?

[@kondareddypulicherla7903]

Previous video lo lookup properties chepthaa annavu...marchipoyavu

[@SreeramReddyB]

But this mapping handling only new rows.

[@babadixit5112]

Can u please give me the details of fact file.
what is fact file were to use detail description.

[@venkatasiva8766]

can u plz explain what extract diff b/w connected and unconnected look up with cache also few points