Latest 40 DATA WAREHOUSING & Firewalls Quetions & Answers Mostly asked in Interviews - Coolinterview.com

DATA WAREHOUSING INTERVIEW QUESTIONS Describe how you would establish the operational (Service)requirements for the data warehouse? http://www.coolinterview.com/interview/43799/   how can we change rows to columns by using pivot stage ,could plz give me the explanation........ http://www.coolinterview.com/interview/37694/   recently i finished my ms in uk in masters in database but i came to india. now i am in die lama which course i need to join either oracle dba or datawarehouse informatic could you suggest me which course have future i mean jobs in india and uk as well thank you http://www.coolinterview.com/interview/35497/   how to see the data from error tables tell me the syntax http://www.coolinterview.com/interview/34490/   what is a ETL? What is Jumk dimension? What is Surrogate Key? What is Dimensional Key? Datawarehouse is a Normalise or not? What is meant by Facts? http://www.coolinterview.com/interview/34350/   What is VLDB? http://www.coolinterview.com/interview/31103/   What is degenerate dimension table? http://www.coolinterview.com/interview/31102/   What is ER Diagram? http://www.coolinterview.com/interview/31101/   What is a CUBE in data warehousing concept? http://www.coolinterview.com/interview/31100/   What is the difference between star and snowflake schemas? http://www.coolinterview.com/interview/31099/   How do you create Surrogate Key using Ab Initio? http://www.coolinterview.com/interview/31098/   Can a dimension table contain numeric values? http://www.coolinterview.com/interview/31097/   What is hybrid slowly changing dimension? http://www.coolinterview.com/interview/31096/   What is loop in Data warehousing? http://www.coolinterview.com/interview/31095/   What is an error log table in Informatica occurs and how to maintain it in mapping? http://www.coolinterview.com/interview/31094/   How Many different schemas or DW Models can be used in Siebel Analytics. I know Only STAR and SNOW FLAKE and any other model that can be used? http://www.coolinterview.com/interview/31093/   How can you import tables from a database? http://www.coolinterview.com/interview/31092/   Where the cache files stored? http://www.coolinterview.com/interview/31091/   What is dimension modeling? http://www.coolinterview.com/interview/31090/   What is data cleaning? How can we do that? http://www.coolinterview.com/interview/31089/

Firewalls Interview Questions What are the responsibilities of Data Link Layer? http://www.coolinterview.com/interview/51297/   What are the responsibilities of Network Layer? http://www.coolinterview.com/interview/51296/   What are the responsibilities of Transport Layer? http://www.coolinterview.com/interview/51295/   What are the responsibilities of Session Layer? http://www.coolinterview.com/interview/51294/   What are the responsibilities of Presentation Layer? http://www.coolinterview.com/interview/51293/   What are the responsibilities of Application Layer? http://www.coolinterview.com/interview/51292/   What are the two classes of hardware building blocks? http://www.coolinterview.com/interview/51291/   What are the different link types used to build a computer network? http://www.coolinterview.com/interview/51290/   What are the categories of Transmission media? http://www.coolinterview.com/interview/51289/   What are the types of errors? http://www.coolinterview.com/interview/51287/   What is Error Detection? What are its methods? http://www.coolinterview.com/interview/51286/   What is Redundancy? http://www.coolinterview.com/interview/51285/   What is VRC? http://www.coolinterview.com/interview/51284/   What is LRC? http://www.coolinterview.com/interview/51283/   What is CRC? http://www.coolinterview.com/interview/51282/   What is Checksum? http://www.coolinterview.com/interview/51281/   List the steps involved in creating the checksum. http://www.coolinterview.com/interview/51280/   What are the Data link protocols? http://www.coolinterview.com/interview/51279/   Compare Error Detection and Error Correction http://www.coolinterview.com/interview/51278/   What is Forward Error Correction? http://www.coolinterview.com/interview/51277/