Close [X]
LOG IN
Close [X]
PLEASE LOG IN OR REGISTER

Sorry, you need to be a registered member and logged in to access this page.
Please login or register below.

REGISTER

It's easy, quick and FREE!




  1. #1
    ashukrishna is offline Silver ILite
    Join Date
    Mar 2008
    City
    chennai
    State
    tn
    Country
    India
    Posts
    550

    Default need interview questions for datawarehousing

    hi frnds...
    can any1 provide me interview questions, any books, links, documents for datawarehousing(informatica, bo,cognos) pls....
    i'm in search of job very seriously as i have to takecare of my family...

    awaiting for ur valuable rpy
    cheers!!!:)
    ashu


  2. #2
    Nandshyam's Avatar
    Nandshyam is offline IL Hall Of Fame
    Join Date
    Oct 2006
    City
    North Brunswick
    State
    Garden State
    Country
    United States
    Posts
    5,436

    Default Re: need interview questions for datawarehousing

    Dear Ashu,

    Datawarehousing is an ocean. Do you have any SQL experience before.

    Its not a great idea to master of Informatica, Cognos, etc in a single shot. You need to follow a definite path, thats Y.

    First before going into DataWarehousing, you need to have a good knowledge about SQLs and PSQLs. Then got to expertise urself in SQLServer or Oracle or any other DB.

    Anyhoo, Larry Greenfield's site: The Data Warehousing Information Center is a great starting point for general background in data warehousing.

    Few interview type questions:

    1. Tell me about cubes
    2. Full process or incremental
    3. Are you good with data cleansing?
    4. How do you handle changing dimensions?
    5. What is a star-schema?

    Data Warehousing questions:
    1) What is source qualifier?
    2) Difference between DSS & OLTP?
    3) Explain grouped cross tab?
    4) Hierarchy of DWH?
    5) How many repositories can we create in Informatica?
    6) What is surrogate key?
    7) What is difference between Mapplet and reusable transformation?
    8) What is aggregate awareness?
    9) Explain reference cursor?
    10) What are parallel querys and query hints?
    11) DWH architecture?
    12) What are cursors?
    13) Advantages of de normalized data?
    14) What is operational data source (ODS)?
    15) What is meta data and system catalog?
    16) What is factless fact schema?
    17) What is confirmed dimension?
    18) What is the capacity of power cube?
    19) Difference between PowerPlay transformer and power play reports?
    20) What is IQD file?
    21) What is Cognos script editor?
    22) What is difference macros and prompts?
    23) What is power play plug in?
    24) Which kind of index is preferred in DWH?
    25) What is hash partition?
    26) What is DTM session?
    27) How can you define a transformation? What are different types of transformations in Informatica?
    28) What is mapplet?
    29) What is query panel?
    30) What is a look up function? What is default transformation for the look up function?
    31) What is difference between a connected look up and unconnected look up?
    32) What is staging area?
    33) What is data merging, data cleansing and sampling?
    34) What is up date strategy and what are th options for update strategy?
    35) OLAP architecture?
    36) What is subject area?
    37) Why do we use DSS database for OLAP tools?

    Business Objects Popular Q&A:
    38) What is a universe?
    39) Analysis in business objects?
    40) Who launches the supervisor product in BO for first time?
    41) How can you check the universe?
    42) What are universe parameters?
    43) Types of universes in business objects?
    44) What is security domain in BO?
    45) Where will you find the address of repository in BO?
    46) What is broad cast agent?
    47) In BO 4.1 version what is the alternative name for broadcast agent?
    48) What services the broadcast agent offers on the server side?
    49) How can you access your repository with different user profiles?
    50) How many built-in objects are created in BO repository?
    51) What are alertors in BO?
    52) What are different types of saving options in web intelligence?
    53) What is batch processing in BO?
    54) How can you first report in BO by using broadcast agent?
    55) Can we take report on Excel in BO?


    More here:

    Data Warehousing Interview Questions

    Also for individual ones you have links with these names:

    Abinitio Interview Questions
    Analysis services Interview Questions
    Data Warehousing Basics
    BO Designer Interview Questions
    Business Intelligence Interview Questions
    Business Objects Interview Questions
    Cognos Interview Questions
    Data Warehousing Concepts
    BO Data Integration
    DataStage Interview Questions
    ETL Interview Questions
    Impromptu Interview Questions
    Informatica Interview Questions
    MicroStrategy Interview Questions
    Reportnet Interview Questions

    Nandhu

  3. #3
    ashukrishna is offline Silver ILite
    Join Date
    Mar 2008
    City
    chennai
    State
    tn
    Country
    India
    Posts
    550

    Default Re: need interview questions for datawarehousing

    hi nandhu ..
    thanx a lot for ur valuable rpy...Bow
    i have wrkd with sql n little oracle... jus like a beginers level...
    but i have deep intrest in tis line...
    unfortunately.. i had no way to proceed ... nw i plan to takeup a course on dwh from ny institute...'ll tht wrk...
    pls rpy
    chers!!!:)
    ashu


  4. #4
    Padma3's Avatar
    Padma3 is offline New ILite
    Join Date
    Mar 2008
    City
    Chennai
    State
    TAMIL NADU
    Country
    India
    Posts
    43

    Default Re: need interview questions for datawarehousing

    hi ashu .. if you are still looking for job in Business Intelligence tools side or in which specific area in datawarehousing? so we can discuss about it further.


  5. #5
    Saahithya is offline Silver ILite
    Join Date
    May 2008
    City
    USA
    State
    USA
    Country
    United States
    Posts
    861

    Default Re: need interview questions for datawarehousing

    Ashu

    hope you got the required information. If not try this site geekinterview.com...it has questions related to lot of technologies.


  6. #6
    ashukrishna is offline Silver ILite
    Join Date
    Mar 2008
    City
    chennai
    State
    tn
    Country
    India
    Posts
    550

    Default Re: need interview questions for datawarehousing

    dear padma...
    rite now i'm looking for informatica
    ya... sure we 'll discuss...
    cheers...!!!:)
    ashu
    Quote Originally Posted by Padma3 View Post
    hi ashu .. if you are still looking for job in Business
    Intelligence tools side or in which specific area in datawarehousing? so we can discuss about it further.



  7. #7
    ashukrishna is offline Silver ILite
    Join Date
    Mar 2008
    City
    chennai
    State
    tn
    Country
    India
    Posts
    550

    Default Re: need interview questions for datawarehousing

    hi saahithya...
    thanx a lot for your valuable reply...
    sure 'll do it...
    cheers...!!!:)
    ashu
    Quote Originally Posted by Saahithya View Post
    Ashu

    hope you got the required information. If not try this site geekinterview.com...it has questions related to lot of technologies.



  8. #8
    datawarehousing is offline New ILite
    Join Date
    Aug 2009
    City
    chennai
    State
    Tamilnadu
    Country
    India
    Posts
    1

    Default Re: need interview questions for datawarehousing

    Hey guys..my advice don't depend on the interview question,all u have to do is to read the whole book throughly with goof logical reasons,that makes us a better person,to know more about datawarehousing visit our site.


  9. #9
    pavuluris is offline Junior ILite
    Join Date
    May 2009
    City
    los angeles
    State
    california
    Country
    United States
    Posts
    182

    Default Re: need interview questions for datawarehousing

    Ladies,

    I have been working in the DWH/BI fields, for quite sometime now. Please feel free to let me know if i can be of any help.

    Take Care,
    --Sireesha.


  10. #10
    melina386 is offline New ILite
    Join Date
    Dec 2009
    City
    CA
    State
    CA
    Country
    United States
    Posts
    1

    Default Re: need interview questions for datawarehousing

    nice discussion and thanx for posting


    Last edited by IL_Admin; 13th January 2010 at 03:17 PM.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT +5.5. The time now is 10:40 PM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283