I would encourage those asking for the answers to actually do some research and find the answers.
You may learn answers to more that way. If you were to get a job based on memorizing a set of answers like this, I am sure you would have difficulty succeeding once you got into the position. When I interview candidates, I dig a little deeper if they give me a “text book” answer to make sure they understand the answer.
I often also give a written test. Use the list of questions as a guide to things you should actually know. It is a good list.
I fully agree with you on u r view that one has to find out answers as that will give them more understanding of the subject. May I suggest that it will be useful you can give a link to some of the useful sites which are helpful to the candidates…….hope you find it fit to reply this suggestion.
There are quite a few places to find answers as part of learning process. I think the first thing that anyone who wants to take up a DW Career should do is read ” The Data Warehouse Toolkit” and half of the questions would already be answered. Rest are tool specific and am sure that the help within the tool will provide ample information.
I am interested in taking up Data warehouse career. Would you please send me the answers for the interview questions, so that i can update myself and build confidence level to attend interviews. If so i will be greatly thankfull to you
hi friends
i am srinivas…i have some doughts regarding informatica
1)what is complex mapping? plz send coplex mapping design if any?
2)how much is your repository size?
3)how many flat tables can we call by lookup t/r at atime?
1)what is complex mapping? plz send coplex mapping design if any?
2)how much is your repository size?
3)how many flat tables can we call by lookup t/r at atime?
4)wat is parameter file?
5)wat is the excat use of mapping parameter?
6)
I agree with John and the best part is DW tool kit and ETL tool kit. These two will give foundation to DW and later learning tools to implement these methodologies will be easy which can be related by understand the features provided by Informatica or Datastate and like wise BI tools like BO,COGNOS etc.
Apart from all these we should understand how we can use database features and drive DW to higher standard, write/develope maps/jobs with good performance. These are skills you should concentrate while you start your career and continue the same. Please teach others and you will become master as they ask more questions you will have to learn more to answer those questions. :) Good Luck.
Ref: DM review, twdi, database, datamodel.org are some of the resources, Read and contribute to those sites if possible they have taken effort to put things together.
11 Comments on Data warehouse interview questions
Sir, Plz send me the answer of Question of related to Data warehouses
hello,
please send me the answers to questions on datawarehouse.
thanks
Could you pls send me the answer to the Questions related to Data warehouse.
Regards,
Manoj
I would encourage those asking for the answers to actually do some research and find the answers.
You may learn answers to more that way. If you were to get a job based on memorizing a set of answers like this, I am sure you would have difficulty succeeding once you got into the position. When I interview candidates, I dig a little deeper if they give me a “text book” answer to make sure they understand the answer.
I often also give a written test. Use the list of questions as a guide to things you should actually know. It is a good list.
Dear John,
I fully agree with you on u r view that one has to find out answers as that will give them more understanding of the subject. May I suggest that it will be useful you can give a link to some of the useful sites which are helpful to the candidates…….hope you find it fit to reply this suggestion.
Vijay,
There are quite a few places to find answers as part of learning process. I think the first thing that anyone who wants to take up a DW Career should do is read ” The Data Warehouse Toolkit” and half of the questions would already be answered. Rest are tool specific and am sure that the help within the tool will provide ample information.
Regards,
Sid
I am interested in taking up Data warehouse career. Would you please send me the answers for the interview questions, so that i can update myself and build confidence level to attend interviews. If so i will be greatly thankfull to you
Currently working on Business Intelligence (Reporting Domain). I want to work on warehouse domain. Please send me answer of these questions.
Thanks and Regards
hi friends
i am srinivas…i have some doughts regarding informatica
1)what is complex mapping? plz send coplex mapping design if any?
2)how much is your repository size?
3)how many flat tables can we call by lookup t/r at atime?
pls friends ,
help me.
1)what is complex mapping? plz send coplex mapping design if any?
2)how much is your repository size?
3)how many flat tables can we call by lookup t/r at atime?
4)wat is parameter file?
5)wat is the excat use of mapping parameter?
6)
I agree with John and the best part is DW tool kit and ETL tool kit. These two will give foundation to DW and later learning tools to implement these methodologies will be easy which can be related by understand the features provided by Informatica or Datastate and like wise BI tools like BO,COGNOS etc.
Apart from all these we should understand how we can use database features and drive DW to higher standard, write/develope maps/jobs with good performance. These are skills you should concentrate while you start your career and continue the same. Please teach others and you will become master as they ask more questions you will have to learn more to answer those questions. :) Good Luck.
Ref: DM review, twdi, database, datamodel.org are some of the resources, Read and contribute to those sites if possible they have taken effort to put things together.
Cheers !