Data Warehouse Interview Questions
Questions Answers Views Company eMail

What are stage variables?

628

What are orabulk and bcp stages?

638

What is datastage engine?

721

How do u convert the columns to rows in datastage?

683

What all the types of jobs you developed?

660

What all are the different way to run a job?

633

What are the enhancements made in datastage 7.5 compare with 7.0?

702

What is datastage?

640

What are the main features of datastage?

653

What is the difference between hashfile and sequential file?

705

Where the datastage stored his repository?

607

What is merge stage?

754

What is container and then types?

1 1063

What are the functions used for character handling?

631

What is proc sort?

710


Un-Answered Questions { Data Warehouse }

What do you understand by user class in cognos?

526


Explain are data mart and dwh normalized or denormalized? Do both of them exist in

578


What is an error log table in informatica occurs and how to maintain it in mapping?

552


explain abt ur project architecture?

1749


How to test a cube?

1667






Explain what are the various transformation available?

529


Tell me about Dnamic and Static Dashboards?

1859


What are the etl testing operations includes?

575


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

1644


What is a cursor? Within a cursor, how would you update fields on the row just fetched?

646


Explain the importance of data warehouse?

559


Describe stream connector?

817


Explain pmcmd command usage in informatica

693


how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

3454


Differentiate between a repository server and a powerhouse?

565