DSXchange

Thanks SURA. We think the approach would be to "Select & Wait" for extra minutes before proceeding with any action. We tried to delete another project by selecting it, waiting it and delete. It worked fine. Thanks for your help.

Hi, We deleted a DataStage project through "Infosphere DataStage Administration" window. We selected the right project and waited for project path to get populated(As it is bit slow) and then slected "Delete". What happened is, we selected project A to be deleted, but project B g...

Thanks, does this istools export design, executable, dependents etc. Or, what are the objects or assets that will be exported as a part of this istools export.

Hi, I am using "dsexport.exe" to get a export dump of full project. This command takes only the job design and not the executables. The option "/EXEC" which helps to get only executables can be used in conjunction with "/JOB", so is there an option to get full project d...

The Output is
LIST.ITEM VOC "DSD.SendEvent" 16:46:26 31-08-12 PAGE 1

DSD.SendEvent
001 V
002 DSD_BP.0/DSD_SendEvent.B
003 B
004 BN
009 DSD_BP.0

This is happening only in one of the project created recently, the projects created previously in the same box does not throw this error...I assume, SendEvent source code exist..

Thanks

Hi, We have been getting this warning in Server job of 8.5 version. Irrespective of the server job, the error is as follows DataStage Job 348 Phantom 16719 Program "DSD.SendEvent": Line 524, Unable to execute the operating system file "-option01". [ENOENT] No such file or directo...

Hi, This may be old question but asking it again, could not find in search. According to documentation the Oracle connector stage offers better functionality and performance replacing some stages which have been deprecated. Is there a real functionality difference in the way the oracle connector sta...

More information may help all. At high level consider Datatype (Char or varchar). Also do you perform any trim operations? Consider APT_STRING_PADCHAR value, is this affecting data in any way

Thanks bkamila. I could not find any options or parameters where I can specify the default log directory path in oracle connector stage. Can you specify options or where can i specify the default" path? Sorry, if my question is weird

Do Oracle Connector stage generates log files in Bulk load options? I could not find them in scratch disk.

Hi, When using Oracle Connector for bulk loads(SQL Ldr, DIRECT=TRUE),do they create logs, in any place, either scratch disk or some directory ? Or do they store these information in any utility tables ? When using Enterprise Stage for Bulk loads, there are logs created in scratch disk locations ? Pl...

Hi I am using Teradata stage as reference data for a Lookup stage. After key lookup between primary and referece stage, column extracted is DATE datatype. Problem -------- If lookup fails then, output DATE column is populating default date as "0001-01-01" Is that how the stage behaves for ...

Hi I am using Teradata Multiload stage. in this using Plugin Metadata, I am trying to import some column metadata. As I am typing Teradata Directory , Username & Password, I am getting the following error. Unable to connect to Teradata Data Source SDMCUM. MTDP:EM_NOHOST(224):name not in HOSTS fi...

Hi

I am passing a date parameter(22-10-2008) as an input to a column. I need, output as given date -1. I tried
date -1 in transformer stage, but job not getting compiled. Is this not the right way to get DATE -1 . How can this be achieved.

Thanks