DSXchange

Thanx a lot guys.. I have taken up two solutions to the Top Management.. 1. FTP a file to windows, which will be picked up by a batch job and start the cube refresh 2. Use Remote Shell I guess the first option will be preferred. Thanx a ton for all your replies.. they were really helpful in arriving...

sorry guys.. didnt check that one..



Is it possible to share the source code for ExecDos..
I will make it as a Routine (with copy rights intact).. and run it..


Nagesh

Hi I have a windows batch file which has to be run after the ETL load completes. This is needed to refresh the Cognos Cube. The Datastage is installed on Unix Box and I want to use the ExecDos subroutine in the "After-Stage Subroutine". But I cant find ExecDos in the drop down. I searched ...

Hi ! I tried doing the same mapping in two ways.. 1. By using custom SQL for the Source 2. By using SQL builder for the source It was a load with 1 lookup (hash file). Source (oracle) table has 27,00,000 records. It took considerably more time when I used Custom SQL than it took when I used SQL buil...

I would recommend using of SEARCH functionality provided, before you post in the forum.

Hope this article helps viewtopic.php?t=92652&highlight=keymgtgetnextvalue

Thats exactly what I did.
:D

Thanks Guys


-Nagesh

Hi !

I tried doing it .. but I dont get option to rename.

try

viewtopic.php?p=147778&highlight=#147778

Alternatively try calling a Windows batch file, with FTP commands, from the server job.

Hi ! One of the developers has imported table definitions with Fully Qualified table definitions checked on.. The tables are now defined as "wms_dw.factTable" (for eg).. I tried to change the Fully Qualified name thru the Datastage Manager, but that is Greyed out. Is there a way of removin...

is this something to do with access permissions on the XML file ?
make sure that the XML file is readable and is not opened by another user or job when it is being accessed in this job.

oops.. the link for lookup should have been on the top of the transformation.

sorry for that


also ensure that ur array size is optimal

Try to use InterProcess stage.

To conditionally trigger the sequence.. try the following Try to create an empty file from the transformation file. The name of the file will be different based on different conditions. ie., If condition 1 is true.. then the file name cond1.ind will be generated. if condition 2 is true then the file...

does oracle all to insert null values in a timestamp field thru ora oci
stage

You can insert NULL value into Oracle column of datatype DATE by using @NULL in the derivation part