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 todays deltas 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 todays deltas started at 1.00 pm, will pickup employee master data(5.pm)?
It comes in next days delta load? Or not?
I think todays delta pickup only changed and newly created records of today . It doest 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