Friday, November 28, 2008

Constraint based Loading in informatica

In the informatica there some serious issues on Constraint Based Loading like the CBL – for level 3 tables where informatica server cannot read the difference between the dimension and flake dimension when we are loading at the same time to solve this issue better use flat file to load instead of child tables and then load to the child tables.

It cannot handle recursive/repetative relationships.

No comments: