Best Training institutes ,Computer education and Coaching classes in Tavarekere as of September 21, 2018

DATA VEDIC institute located at tavarekere in bangalore offers 21 Day(s) of Informatica training course in Bangalore with 100% Placement Assistance.

Has 9 Yrs of Real time experience in MNC and 4 Yrs in teaching experience. Trainer will support with a demo project & technical support even at real time projects. Will take mock interviews & help in

INFORMATICA COURSE CONTENT Session-1 � Introduction to Data Ware House � Introduction to OLTP � Difference between OLTP and DWH � Dimension table � Fact table � Architecture of DWH � Star schema � Snowflake Schema � Data mart � Top down approch � Bottom up approch � ETL Session-2 � Types of ETL s � Code based � GUI based � Introduction to Informatica � Domain � service � Node � Informatica Power Center 9.1/9.5 � Archtecture of Informatica � Repository � Repository service � Integration service � Informatica server component � Informatica client component Session-3 � Introduction to Admin tool � Introduction to client tools � Developer � Workflow manager � Workflow moniter � Repository Manager � Importing/creating source defenition � Importing/creating target defenition � creating Mapping � Creating session � creating workflow � Executing the Workflow � Monitoring the workflow � Understanding session log Session-4 � Working with Transformations ( Connected,unconnected,Active,Passive) � Expression � Filter � Sorter Session-5 � Aggregator � Rank � Seq generator � Router Session-6 � Union � Update Strategy(Options in session level) � Transaction control � Working with flat files � Normalizer Session-7 � Source qualifier � Joiner � Look up Session-8 � Stored Procedure � SQL Transformation � XML Source Qualifier Session-9 � Variable port in Expression � Working with variable port � Multiple pipe lines in mapping � Target load order � Debugger � File list � Constraint based loading Session -10 � SCD type -I � SCD type _II � SCD type -III Session -11 � Caches in loop up � Dynamic lookup � Persistent cache � Shared cache � named shared and un named shared cache � Parameters and parameter file Session-12 � variables � using variables � Performance tuning � Tasks � CMD task � email task Session -13 � Reusable transformation � Reusable Mapplet � Reusable session � Reusable Worklet � Link task � Parallel load � Sequential load � First load and incremental load Session-14 � Timer task � control task � event wait � event raise � decision task � Assignment task Session -15 � (use full in work environment) � Code movement from Dev to production � different methods for code movement � Deployment groups � Check in � check out � What is versioning � Find checkouts � dependencies � Comparing previous versions Session-16 � Partitions � Pass through � Round robin � Hash key � Hash user � Key range � DB Session-17 � Restartability � FAQ � Resume preparation