Guruonline Trainingis a Global Interactive Learning Portal started by proven industry experts with an aim to provide Quality Training in the latest IT Technologies. guruonlinetraining.comhas a pool of Expert Trainers worldwide on all the technologies to train the students. We offer you: Ø Interactive Learning at Learner’s convenience Ø Industry Savvy Trainers Ø Learn Right From Your Place Ø Customized Curriculum Ø 24/7 Lab Facility Support after Training Resume Preparation Certification Guidance Interview assistance Name:Venkat For India-Ph: 07760722117, +91 9290071821 , SkypeId: dataramana.dwh Mail: dataramana@gmail.com, guruonlinetraining@gmail.com, contactus@guruonlinetraining. DATASTAGE ONLINE TRAINING WITH REAL TIME SCENARIOS & PROJECT EXPLAINATION WITH REAL TIME FACULTY. WE ARE OFFERING WITH LOWEST FEE. WE ARE PROVIDING 100% JOB PLACEMENTS FOR USSTUDENTS.WE ARE PROVIDING TRAINING ON DATASTAGE8.1 VERSION-IBM WEBSPHERE DATASTAGE&QUALITY STAGE ANDUPDATE THE STUDENTSABOUT LATEST VERSION IBM DATASTAGE 8da.5 VERSION WITHLIVE ENVIRONMENT. Data ware housing concepts ØAbout data warehousing ØHistory of data warehousing ØData warehousing architecture ØDifferent Data marts ØAdvantages of DWH ØProperties of DWH ØOLTP VS OLAP ØDWH Approaches ØData Modeling ØStar, Snowflake & Galaxy Schemas ØDimension tables ØFact Tables 2.Data Stage Contents ØIntroduction about Data Stage ØIBM Information server overview ØIBM Web sphere Data stage and information Analyzer ØIBM Web sphere Quality stage ØDifference between Server Jobs and Parallel Jobs ØDifference between Pipeline and partitioning Parallelisms ØPartition techniques (Round Robin, Random, Hash, Entire, Same, Modules, Range, DB2, Auto) ØConfiguration File ØDifference between SMP, MPP, Cluster architecture ØData Stage Components (Server components/Client Components) ØPackage Installer 1.Data Stage Administrator ØCreating project, editing project and deleting project ØPermissions to user Ø.Apt Configuration file ØEnvironment variable creation, permission, Job Parameters. 2.Data stage director ØIntroduction to Data stage Director ØJob status View ØView logs ØScheduling ØBatches Creation 3.Designer ØIntroduction about Designer ØRepository ØPalatte ØTypes of Links ØFile Stages ØSequential File ØData set File ØLookup file set ØDifference between Sequential file/Dataset/File set ØDatabase stages oDynamic RDBMS oOracle Enterprise oODBC Enterprise oStored Procedure 4.Processing stages ØChange Capture Stage ØChange Apply Stage ØSort Stage ØCompress Stage ØExpand Stage ØEncode Stage ØDecode Stage ØCopy Stage ØExternal Filter Stage ØFilter Stage ØCompare Stage ØDifference Stage |