Data Warehousing on a Shoestring Budget
Tuesday, July 22, 2008
Found the following links, which still need to be researched/analyzed further.
DM Review : Where are the Articles on Data Warehouse Testing and Validation Strategy?
A Wordpress blog : Strategies for Testing Data Warehouse Applications « Business Intelligence and Datawarehousing
DM Review : Strategies for Testing Data Warehouse Applications
Monday, July 21, 2008
- Connected Lookup
- Unconnected Lookup
Different types of caches can be used with lookup like static, dynamic, persistent, and shared(The dynamic cache cannot be used while creating an un-connected lookup). Each of these has its own identification. For more details, refer to Informatica Transformation Guide.
Lookup is a passive transformation, and can be used either connected or unconnected. Typically, connected lookup is used when you want to do the lookup for all rows. When you have selective lookup requirements, its normally better to go for unconnected lookup. Unconnected Lookup can be used as if its a function call.
To read more, here is a good article -
What is lookup transformation in informatica? - IT Community
Still something I am waiting on... specially since I am back in India and Apple is to launch iPhone in India (officially, though cracked versions are already available). Personally, I am not the biggest fan of cracked phone... :)
nice screenshot tip ..
Go on yOOrek... :)