Hi there, I am working on a Datawarehouse implementation.
I am currently designing a ETL solution using Informatica and have come up with 3 different designs for my ETL staging area.
Overview: There are 3 company books, held across 20 countries.
And here are my options for the design:-
Option 1: 3 large tables based on different books.
Option 2: 1 table holding all the information from all countries and books.
Option 3: 20 tables, one for each country.
The main driver here is performance. It would be great if you could provide some insight into best practice and designs to improve informatica's performance, and help me decide on which option to take.
Links to white papers and examples would be great.