Un-Answered Questions { Data Warehouse }

How can we use external procedural logic in informatica?

544


Do we need an etl tool?

571


What is etl process. How many steps etl contains explain with example?

525


What is a staging area? What is the purpose of a staging area?

503


What are vaious etl tools in the market?

598


What are the measure objects?

682


What are the different types of transformation available in informatica.

652


Explain what are the different types of transformation available in informatica.

590


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

628


How to do unit testing in informatica? How to load data in informatica ?

671


Explain the different dimensions.

572


Differentiate between source qualifier and filter transformation?

1019


Explain scd type 3 through mapping.

602


What is dimensional table?

637


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1041