ETL工程师面试题

《ETL工程师面试题》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、ContentsContents..........................................................................................................................................1DataWarehousingquestions.......................................................................................

2、....................1SQLquestions.................................................................................................................................1Unixquestions..........................................................................................

3、......................................3InformaticaQuestions.....................................................................................................................5MultipleChoice&True/FalseQuestions.......................................................

4、............................5DataWarehousingquestions1.WhatisDataWarehousing?Whydoweneedit?2.Whatisadhocanalysis?3.DescribeOLAPandOLTPsystemsOLAPvs.OTLP:listfivemaindifferences.4.Whatisafacttableinadimensionalmodel?Whatisadimensiontable?5.CharacterizeSTARandSNOWFLAK

5、Eschemas.6.WhatisaSlowChangingDimension?Listallknowntypes;describeimplementationtechniques.7.Whatisalookuptable?8.WhydoweneedDimensionNormalization?9.Listanddescribestoragemodelssupportingmultidimensionalanalysis(listprosandconsforeach).10.WhatisETL?11.WhatisaDataMa

6、rt?12.DescribeSliceandDicetechniques.13.WhatisthemaindifferencebetweenKimball’sandInmon’sapproaches?14.Whatisadatamining?Listanddescribedataminingtasks.SQLquestions1.WhatdoestheabbreviationSQLstandfor?2.Howwouldyoulistalltherecordsinatable?13.WhatisSQL92?Forthenextp

7、art,let'sdefinethefollowingentitiesandrelationships:entityCUSTOMERattributes:CUSTOMER_ID,CUSTOMER_NAMEentityACCOUNTattributes:ACCOUNT_NO,CUSTOMER_ID,BALANCEentityEMPLOYEEattributes:EMPLOYEE_ID,EMPLOYEE_NAME,REPORTS_TOentityPROJECTattributes:PROJ_ID,PROJ_NAME,PROJ_LO

8、CATION_ID,PROJ_CITYThefollowingbusinessrulesmustapply:ThefieldREPORTS_TOisnullforexactlyoneemployee,otherwiseitisoneofthenumbersfoundincol