![]() ![]() Processes such as, Order Fulfillment, Inventory Analysis,= SAP, Peoplesoft, etc.) will help separate= ![]() Kimball concepts if the customer is hard-set on Inmon).Īnything you can bring to the table regarding the customers=īusiness systems (i.e. To get the customers perspectives (you do not want to push= (for 10g there is the new Bitmap join Index).Īlways, Always offer details of your knowledge, and ask questions= Indexing (when to use), and any other specifics as related to DW= Views and Materialized Views, Partitioning, Bitmap= In Oracle you can talk about referencial integrity as it applies= Know how ERwin treats dimensional modeling.Īnything you know about RDBMS is worth discussing. The dimension model feature is pretty weak, but you might want to= Know how to use the Reverse Engineer and Comparison features. Know the difference between Logical and Physical models. How to modify source and target sql overrides, etc. Relational), use expression transformation, lookups (connected=Īnd disconnected), aggregaters, normalizers, update strategies,= Be prepared to demonstrate how to=Ĭreate a connection, source definition (flat file and= Know what the difference is between sttic=Īnd reusable objects for both. You will most likely be asked specific questions for building a= ![]() Informatica 7.x has divided the developer and= Let them know which version you are familiar with as well as what= Talk about challenges of real-time load processing vs. Talk about the concepts of ODS and information factory. ![]() Talk about the Kimball vs Inmon approaches. I am just a lowly recruiter and not ab initio consultant but hell I feel like I know the product through and through as many interviews as I had to sit in on!!Ī few high level questions might include: These are all basic questions from beginner to higher level to determine what level a consultant is at. How many components in your most complicated graph? How do you add default rules in transformer? Whats the difference between partitioning with key and round robin? How do you improve the performance of a graph? How do you truncate a table? each candidate would say only 1 of the several ways to do this. Have you eveer encountered an error called depth not equal? (this apparently occurs when you extensively create graphs. What is the difference between db config and a cfg file? How many parallelisms in ab initio and a definition of the three? What is the function you would use to transfer a string into a decimal? Just went through 8 Ab Initio interviews and some of the tough questions were as follows: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |