DSXchange

I never worked on shared containers. How should I call the container in my job. Create a shared container. Calling is not difficult. Just drag n drop. :? But before i joined the current project, they had same problem and they implemented shared container to solve it. If you can send me .dsx file an...

Hi all, My Job design: Seqfile ------> XML Input ------> Xtrans------->Sql server 1)I am trying to extract the xml file and straightly dump raw data into the table I am getting an error in the seq file stage: " <Sequential_File_0,0> Error reading on import. >##E TOIX 000061 14:38:30(001) <Sequ...

DSguru2B wrote:Does the transformer stage work at your end? If you are having compilation problems with that as well then you have to set the compiler and linker environment variables properly. ...

Yep, Transformer stage works fine. So i guess the Compiler options are working fine for VC++ .net compiler.

-Kash.

These are not C routines. These are Orchestrate C++ API's. :? ... Thts right, DSGuru Orchestrate C++ APIs. i have been trying to develop a custom stage using these routines. But as it is under Windows i did not find any supporting document for the same. I started off with helloworld.C to see clear ...

I really appreciate your gesture DSGuru. Here is the code: There are basically two files hello.h and hello.C Basically hello.h has a macro APT_DECLARE_RTTI(HelloWorldOp); now this macro is including <rtti.h>, which in return includes string.h // ------------------------------------------------------...

Thanks Ray, DSGuru The file i have mentioned, is defined in one of the framework include folder. <apt_util/rtti.h> So i am not very confident modifying this file to some other name like "string.h" or <string.h> What is surprising is there is no documentation what so ever for Windows DS EE ...

Hi, I would like to develop a Custom stage in windows environment. I found out that there is no PXEngine/examples in windows server unlike its unix counterpart. So i just copied hello.C and hello.h files in windows and tried to compile with VC++ 7.0 But i got error like <stings.h> not found . I gues...

Thanks DSGuru and Kumar for your workaround methods. Kumar - 12. What you expect for non matched records ? For non matched records, i use function IsNotNull / IsNull But this works only is the input non key field on Right dataset (Reference Dataset) in Left Outer Join is defined as NULLABLE. If non ...

1. Debugging for PX. Server type debugging. Besides Peek, Head ,Tail, Row, Column gen. 2. Ctrl C , Ctrl V of META-Data (Table Definitions) from Sequential File /DB stage (besides Transformer/Copy stage), without saving in MetaData Repository. 3. Coming from java/c++ world, would be nice to Be able t...

Addressing the same issue on Null field handling. I would like to make a small comment. What if we have 1000 columns (very unlikely but...) and they are defined all chars...like Char (100) , char(200), char(500) so forth and so on. In that case we are supposed to modify Null handling property for ea...

First of all very sorry for not replying to my post earlier. I was out of town, so didnt login. Secondly, Thanks Ray for your suggested solution. But i cannot do it, because I need that sequence as a reference (Refrential integrity) in some other table. i.e when i generate the sequence for the same ...

Hi, I am using a parallel job to generate a sequence in Oracle. Every record will have that unique number. I am using a LookUp stage to achieve this. heres how my job looks like: Primary source _______ Lookup Stage _______Output File (ID, Val1,...) (Sequential File) ^ (Key,Val1) Reference Link | Ora...

Hi, How about checking for a trimmed column being an empty string? IHTH, Ofcourse i can do that, only thing i dont want to use a Transformer. Also checking for trimming wouldnt eliminate the warning : Seq_Desc: When checking operator: When validating export schema: At field "ITEM_DESC": E...

Hello everyone, I want to find a solution as to how i can define a NULL for fixed width data type like char (10), decimal(10) date(10) in SEQUENTIAL File Stage in PX, while exporting data to a physical file. * i have nulls in my data. data defn is -> ITEM_DESC CHAR (100) i know if the width is 10, i...