Data stage Online Training course content

1. www.rstrainings.com Contactus:-9052699906 DATASTAGEONLINETRAININGCOURSECONTENT: DATAWAREHOUSEFUNDAMENTALS AnIntroductionofDatawarehousing purposeofDatawarehouse DatawareArchitecture OLTPVsDatawarehouseApplications DataMarts DatawarehouseLifecycle DLC DATAMODELING IntroductionofDataModeling EntityRelationshipModel DimensionsandFastTables LogicalModeling PhysicalModeling SchemasLikeStarSchema&SnowflakeSchemas FactlessFactTables PROCESSOFETL(EXTRACTION,TRANSACTION@LOAD) IntroductionofExtraction,TransformationandLoding

2. TypesofETLtools KeytoolsinthemarketINSTALLATIONPROCESS Windowsserver Oracle .NET Datastage7.5X2&8x DIFFERENCE Serverjobs&Paralleljobs COMPONENTSINDATASTAGE Administratorclint Designerclient Directorclient Import/exportmanager Multiclientmanager ConsoleforIBMimformationserver WebconsoleforIBMimformationserver INTRODUCTIONTOIBMWEBSPHEREDATASTAGEANDQUALITYSTAGE8X DatastageIntroduction IBMInformationserverArchitecture IBMDataQualityArchitecture EnterpriseInformationIntegration WebSphereDataStageComponents DATASTAGEDESIGNER AboutWebSphereDataStageDesigner PartitioningMethods PartitioningTechniques DesignerCanvas

3.  CentralStorage  JobDesigning  CreatingtheJobs  CompilingandRuntheJobs  Exportingandimportingthejobs  Parameterpassing  System(SMP)&Clustersystem(MPP)  ImportingMethod(Flatfile,Txt,XlsandDatabasefiles)  OSHImportingMethod  Configurationfile PARALLELPALETTE DATABASESSTAGES OracleDatabase DynamicRDBMS ODBC SQLServer Teradata FILESTAGES SequentialFile Dataset LookupFileset DEV/DEBUGSTAGES Peek Head Tail RowGenerator ColumnGenerator

4. PROCESSINGSTAGES  Slowlychangingdimensionstage  Slowlychangingdimensionsimplementation  Aggregator  Copy  Compress  Expand  Filter  Modify  Sort  Switch  Lookup  Join  Marge  ChangeCapture  ChangeApply  Compare  Difference  Funnel  RemoveDuplicate  SurrogateKeyGenerator  Pivotstage  Transformer CONTANERS SharedContainers LocalContainers DS-DIRECTOR

5. AboutDSDirector Validation Scheduling Status Viewlogs Monitoring SuppressandDemotetheWarnings Peekview DATASTAGEADMINISTRATOR  CreateProject  DeleteProject  ProtectProject  Environmentalvariables  Autopurge  RCP  OSH  CommandsExecute  MultipleInstances  JobSequenceSettings JOBSEQUENCEAREA JobActivity Jobsequencer StartloopActivity EndloopActivity NotificationActivity TerminatorActivity NestedConditionActivity

6. ExceptionhandlingActivity ExecuteCommandActivity WaitforfileActivity UservariableActivity AddingCheckPoints estartable IBMWEBSPHEREQUALITYSTAGE DataQuality DataQualityStages InvestigateStage StandardizeStage MatchFrequencyStage ReferenceMatchStage UnduplicatedMatchStage SurviveStage ViewingauditdetailsinoperationalDASHBOARDreports KEYSERVICE  FAQS  CoveringDBAconcepts  Concentrationonperformancetuning  Realtimescenarios  Certificationguidance  Resumepreparation  Sampleresumes  Interview&certificationFAQS  Howtofacetheinterview  Classnoteswhichisusefulforwhoistryingforjob

7. Projectpreparation