DSXchange

Do users 1, 2 and 3 read different target tables? Or do you just have one target table but 3 different query requirements? ... The Target table is Single table with 3 different query requirements. The users 1, 2 & 3 may select any columns from col6 to col10 for loading the target table. The col...

We have a requirement is as below: Table A: Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 Col10 All users require Col1 to Col5 to be loaded to the target table. User1 need Col6 & Col7 also to be loaded in the target along with Col1 to Col5. This may change later as the user1 may require Col6, Col...

Hi, I am able to solve this issue by removing the Transformer stage in my Shared Container. I had used Transfomer stage to filter out a single file name fetched using the Folder stage. Now, I am able to read a single file using the Folder stage itself by passing the file name in wildcard property in...

Hi, I have already gone through the post. When I am trying to read the XML file (1600KB) in Server, it is working fine. The same refered in Parallel job (v8.1) as shared container is giving the error "ds_ipcput() - row too big for inter stage rowbuffer ". I tried turning off the row buffer...

Hi, I have created a server shared container for reading XML file. It contains the stages as follows: Folder stage -- > Transformer --> XML Input stage. I am using this shared container in my parallel job where I am getting the error "ds_ipcput() - row too big for inter stage rowbuffer". C...

Thanks Nagaraj. The problem was due to mismatch in the datatype. We are getting a fixed with file and the file is read using schema file definition. The numeric column are read as int32 using schema file and in DataStage the data flow as Integer values. But in the final Oracle table, the columns are...

Sorry...

I didn't force.. Just wanted to know whether the issue was solved or not

Any answer for this issue.

We are using the schema file as below: record {record_delim =' ', final_delim=none, delim=none} ( CTL1:nullable int32 {width=2, null_field=' '}; CTL2:nullable int32 {width=4, null_field=' '}; CTL3:nullable int32 {width=4, null_field=' '}; CTL4:nullable int32 {width=4, null_field=' '}; } While readin...

Thanks Ray.

Yes, it is set ...

Please respond to my new post with subject "UNICODE for CHAR/ VARCHAR2 columns"

Can anyone explains what this UNICODE signifies in column definitions.

We have defined the NLS Lang as UTF8 and all column datatype is VARCHAR2. We are using Oracle database for loading the data

Do we need to define the extended type as UNICODE?

Regards,

Can anyone explains what this UNICODE signifies in column definitions.

We have defined the NLS Lang as UTF8 and all column datatype is VARCHAR2. We are using Oracle database for loading the data

Do we need to define the extended type as UNICODE?

Regards,
Manju