Skip to Content
0
Former Member
Jan 18, 2012 at 11:56 PM

How to write a dummy record into a target if the source has zero records

105 Views

Hello,

I have a requirement to write a dummy record into a Info cube if there is no data to load from a DSO.

So far I have tested the code in multiple places

-Created an APD with a Routine between the Target and Source

-In a transformation between the Source and the Target in Start Routine/End Routine & Expert Routine. nothing worked.. if the source has 0 records the transformation processing is bypassing the start/end or Expert routine code.

I have seen some posts which talked about this scenario but did not help.

Appreciate your time.

Jag