DSXchange

Dear All, Our warehouse project has about 3000 jobs and we need to export the job designs[not the executables] individually without their related shared containers included. I am using a tool to export the jobs individually which uses "dsexport" but it is including the shared containers as...

Dear Ray, I guess my sentence was misleading. Sorry about that. I wanted to get feedback from any of the members of this forum who might have setup something similar in a major scale of sort. Dear DSguruDB, Previously i have created similar environment but for small scale developments within the sam...

No it is not Duke. This is an actual scenario i am facing right now.

No it is not Duke. This is an actual scenario i am facing right now.

Dear All, Would like to put forward this question as well: Our company has a datawarehouse and we have merged with a new company that does not have a datawarehouse and now we are to combine/merge the new company's data into our existing datawarehouse. I would like to know from everyone in this forum...

Dear All, Would like to put forward this question: We are to prepare a datastage development environment for implementation and testing of a datawarehouse module. What are the consideration to be addressed in preparing one? I would like to get feedback from everyone in this forum. Thanks in advance.

Thank you everyone for the inputs. Learned something new through this post. Appreciate it.

Have a nice day.

Dear Ray and Duke,

Indeed the "BIT" must be in upper case. That solved the issue.


Thank you very much.

Dear Ray, I am not a premium poster so unable to read your full reply but was able to capture the command.Here what i did: i. mkdbfile /crdrsk/data/HASH/PRV_MTH_ST_TEST 30 1 4 20 50 80 1639 - 64bit - The file was created successfully. ii. executed SH -c "od -x /crdrsk/data/HASH/PRV_MTH_ST_TEST/...

Ray i already created a pointer entry into VOC and executed the following command "UVFIXFILE hash_filename VLEVEL 0 TRACE 1" but the command screen was blank with the close button activated.

Dear All,
How or what command can i use to check whether a hash file is 64bits or not.

Thanks in advance.

Dear All, I have created a server job with one Source (Sequential) One transformer and one Target (DB2). The mappings are quite direct. The Target's Update Action='Update existing or insert new rows'. I would like to do the following: Split the Source into 2 links one for update and one for Insert a...

loveojha2 wrote:Can you get it working by having separate stages for the three queries?

I am testing this one currently.

Dear All, I am facing an issue with my ETL job and the details are as follows: The job is retrieving data from DB2 table and writing to a hash file. There is 3 links which executes 3 different SELECT query from 3 diff tables and writes to 3 different hash files. Scenario: 2 of the links manage to fi...

Dear All, Few days ago, one of the project work folder reaced 99% space usage and hanged.We managed to identify the issue and increased the space. The ETL batch managed to resume as normal but another problem arised. Whenever I tried logging in using the dsadm id to either Manager/Director/Designer ...