DSXchange

Hi.. All We are Developing Fact Job... I have some Questions 1) Suppose if we have 15 dimension in one Fact Job --> we are using 7 Dimension Hash Lookup in to one Single Transformer.. and another 8 in another transformer... so which design will give better performance... is it ok..if we give all the...

Hi.. can any one know how to load one single row into Hash file....which exist in the project... my problem is i have 20 lookups in my Fact job.. i want to match the data of HASH files with the Data coming from source Fact Table... I want some shortcut method..so if through some routine or some job ...

hi... man first i will give u answer of incremental load..we are using loading strategu as "Update or insert" so every time we are comparing TimeStamp with LaslModifiedDatetime which is going to be passed through sequencer then lony new updated 5 rows will pass ..and written into the stagi...

hi... i am working in Peoplesoft EPM ASCL jobs... i am creating all staging,Dim and Fact jobs.... so we can contribute....toeachother and to this site... i will appreciate ur interest..... * This post is for guyz on Peoplesoft EPM ASCL jobs...Others, please excuse this post* hello all.. I saw a post...

hi..
can any one tell me..that..
if i give one template ...can i make job automatically...generated..
like if i pass source table details and target table details ...
can i do...
automatic job generation...
contact me......
my id phd21@rediffmail.com
phone no: 919886135740

hi.. Prashant u have to apply the patch for Ascential r1. if u want i can send to u.. my mail id is phd21@rediffmail.com himanshu We are facing problems while working on DataStage server jobs. some of the error are like 1) Can not open DSR_JOBS 2) Error calling subroutines:DSR_EXECJOB(Action=1) ;che...