Skip to Content
0
Former Member
Sep 21, 2005 at 06:32 AM

Delta and Repeat delta

15 Views

Hi all,

I have a doubt pls clarify.

I am filling my cube from employee master. Delta loads are scheduled at 1.00pm Daily.

For example employee :222456 master will load at 4.00 pm today.

1.) Is today’s delta’s started at 1.00 pm, will pickup employee master data(4.pm)? or

It comes in next days delta load? Or not?

Previous record is changed today at 5.pm

2.) Is today’s delta’s started at 1.00 pm, will pickup employee master data(5.pm)?

It comes in next days delta load? Or not?

I think today’s delta pickup only changed and newly created records of today . It does’t take up (4/5pm records) once it is started even it is available master data today. Please correct me.

So Those are missed (4/5pm) in cube but available in employee master.

To maintain these Repeat delta is solution? I fear this causes any double entries ?//

Please advise and clarify

Warm regards,

sri