How will you load you daily/monthly jobs datas in to Fact and
Dimension table using datastage.
No Answer is Posted For this Question
Be the First to Post Answer
How will you move hashed file from one location to another location?
Difference between the Sequence and Sequencer in DS?
if ename='subbu' while running job the job should be abort how come?
If the job aborted in a sequencer, how can we start that from the previews successful job.
What is diff between Junk dimensions and conform dimension?
if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA
1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...
root tree will find which is server job and which is parallel job?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How can you write parallel routines in datastage PX?
What is PX?
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?