records failing to load while using lookup.

[LEO]

Hi,

I have source query which is giving me some 1250 rows of data.
However, in the next step of process in build, it is looking up for 5 keys from 5 different lookup tables.

1140 records got the keys in lookup table, so successfully loaded into target.

But the remaining rows didnot got inserted as the keys were not present in one of the lookups.

i want to insert those rows even if they don't have the key, I want to know if there is a way to implement this keeping all these lookups as it is.

I appreciate any thoughts on this.thanks in advance.

regards,
Leo

[templa73]

Hi
Just right click on your dimensions and select dimensions properties and on Unmatched Members, just select Accept the unmacthed members identifiers.
thanks

[LEO]

Hi,

thanks a lot. It worked perfectly...


regards,
leo