DSXchange

Hi We recently migrated our dev project from one linux box "A" to other linux box "B". There was a job, which creates a hash file from a table as follows. DB Stage -> Hash File The number of records in DB : 2,471,947 records It took 10 mins in our earlier "A" system (at...

Thanks chullet and dsdevper

The better solution is parameters, I agree.

But will it give correct results, if we do export , replace all, then import back...?

Later on ... we will parameterize every thing...

Thanks for suggetions
Sai

Hi While doing migration of project from one database schema of the tables (i.e. SCHEMA=A)to another database schema(i.e. SCHEMA=B), the corresponding jobs that uses these schemas should be changed accordingly. We found that the way is about to do export and do replace all from old schma to new sche...

Hi When we try to do export/import any object in the project from manager... we are getting the following error. This errors are for export: MyCreateObject: Internal error - Could not create object with OLEType=VMDataStage.CDSRProgress CDSRepos.Initialize: Internal error - Could not create frmProgre...

Thanks ray, Chullet... Whatever you said is right for cat option...I would see this in practical.... For Folder stage...I went through documentation ..it can have only two outputs, i.e. filename and file content...May be this is ideally suited to XML documents reading... I wanted to know whether fol...

why not folder stage??

Hi Chullet, Ray

I was not selected cat filter because the size of each file is huge ... The cat operation will take lot of resources...

Thanks
Sai

I would like to use the first approach u hv told... i.e. Folder stage..

How do we pass the output of folder stage, (i.e list of files in the folder) in the "column name" of folder stage to the "file name" in the sequential file stage?


Thanks
Sai

Thanks Ray and Chullet

Thanks Ray and Chullet

Hi We have designed a job which has the following structure SeqFile -> Tfm -> OraBulk If I want to load more than one file(for ex: 100 files) to the same Database table using the same job, is there any best way to do this? In Oracle, there is an external table concept with which we can get the data ...

What can I do now to make dssearch work properly?

Should I add manually this entry in dependencies??


Thanks
Sai

Sorry chullet

The jobs were listed in the dependencies tab... the "missed job/sequence" is not listed... U r right..

But I didnt add this list in dependencies.... How it is been added here ? and how "missed job/sequence" is not added in dependencies??


Thanks
Sai

Not listed..Even the not missed jobs also not listed in dependencies tab of the sequences.

When I trying to run the master_sequence, ...The missing job/sequence is also running fine...