DSXchange

Hi,

Just wanted to check if anyone has had a chance to work with the latest Datastage offering DS 11.5 on the Hadoop cluster.

Just trying to assess how easy/difficult will it be to integrate it with an existing hadoop cluster and any references that anyone can share.

Hi, I wanted to check if anyone has installed DS8.7 on a Hadoop cluster. Can we put $DSHOME directory of HDFS and leverage the power of Hadoop's distributed computing. I intend to have the datasets, source/target files on the hadoop cluster anyhow. Just wondering if putting $DSHOME on HDFS gets me a...

Try this:

SELECT TRIM(TableKind) as TableKind FROM DBC.Tables WHERE DatabaseName = 'DB_NAME' AND TableName = 'Table_Nm'

Yes Ray, parameter set migration was done. Let me repeat, the problem is occurring sometimes, it is not occurring for all the jobs. Had the parameter set not been migrated, all the jobs would have given this problem. And I see this problem only for Connector stages - both DB2 & Teradata. The ent...

Had the values been incorrect in DSParams file in QA, this problem would have happened for all the ETL jobs, but this problem is occurring sometimes, and I don't see any pattern in the occurrence of the problem. It is weird....

Yes, the value in the parameter set it is given as $PROJDEF.

So, if the parameter set is: ParamSet
parameter name is: Param1

In the ETL job, I'm using : #ParamSet.$Param1#

Hi, I'm facing a strange issue with the parametrization of values in DB2/Teradata Connector stages. All the DB related parameters - DBname, DBSchema, DBpassword are passed to the Db2/Teradata Connector stage using a parameter set. Still, when I compile and migrate the job from one environment to oth...

Hi,

Thanks a lot Chulett, it now works with a minor modification:

dscmdimport /H=host /U=test /P=pass /O=N /NUA Proj_test C:\DSX\Test.dsx

for usage analysis as disabled, and:

dscmdimport /H=host /U=test /P=pass /O=N Proj_test C:\DSX\Test.dsx

for usage analysis as enabled

Well, had it been working then I might not have posted this thread altogether, anyways, its not working giving me the message: "Failed to attach to project".

Hi, I am trying to make use of command line import utility for Ascential Datastage 7.5. The help that I could get from Datastage was : dscmdimport [/H][/U][/P][/O][/NUA] project|/ALL|/ASK filepaths [/V] /H Host name. /U User name. /P Password. /O Omit flag. /NUA Suppress usage analysis. project Spec...

This hash file acts as a shared lookup across different warehouses(In my case warehouses differ on the basis of line of business - Finances, HR, etc..). and all the rows are needed.

If I use an IPC stage between a DRS stage and a hash file, will it improve the performance. I'm trying to load data from an Oracle DB table containing around 3 million records into a hash file and it took around 30 minutes, I want to improve upon this.

Hi, is there any way of getting the list of tables used as source DRS, lookups and target DRS in the ETL job.

1. Warning - Error occurred during link open processing. (while sending data to the Lookup transformer) 2. warning - DSP.Open GCI $DSP.Open error -100. 3. Fatal - DSP.Open GCI $DSP.Open error -100 (while sending data to the error transformer) If the SQL query for pulling data from the source is run ...

I am getting the following error message - "DSP.Open GCI $DSP.Open error -100" while running a server job. Data is being pulled from DB2 datasource.