DSXchange

I changed the file content to 2147483648 and tried both Integer and Unsigned Integer. I am able to understand now.

How about Varchar with Extended Unicode ? Can anyone give an example?

All, I have created some test job to understand the Sequential File's Extended property - Unsigned. I have designed a simple job as below. int_test.txt 1234567890123 seq_file_stage --> copy --> seq_file_stage column: t - integer -- extended = Unsigned It is same for both the input & output file....

UCDI, Thanks for your time and explanation. I need to read it once again to understand more on this.

Ray, NLS is installed and enabled in my project..I can see NLS tab in the job properties. But when I see the NLS tab, I can see Project Default (UTF-8). is it something overwritten during installation ?

I am curious to know What DLL's are common to both ?

All, This issue is fixed now. I am able to open Designer. Internet Explorer was crashed in that machine, so i removed it and re-installed it once again in that machine. i did this just to use IE. But When I open Datastage Designer, It just opened :) I dont believe it..How? I really don't understand ...

Hi ,

I would like to install the licensed version of Datastage 11.X in my HOME PC for LEARNING Purpose.

Where can i get it ?
What would be the cost ?

Thanks,
Karthik

any help ?

Hi All, I have been facing a weird issue with respect to accessing project since last week. When I try to login in Datastage Designer, I am getting the below issue. ------------------------------------------------ The session [5CDF8D5D-22A1-406E-A4CB-5811BFACB2C3] has expired or was not found. -----...

ray.wurlod wrote: Between source and join generate a column that identifies the source.

I am not clear on this point. Can you explain little bit more?

Actually we receive 2 files as I said in my first post...But the transpose logic will transpose the file (including some other logics) and give the result which I mentioned in my second post...

yes.. But this is what my requirement...

Sorry...the file is in the below format.

Market Model Ind Reg
MK1 M1 5 0
MK2 M2 15 0
MK1 M1 0 50
MK2 M2 0 150

All, I am working on the below requirement. Table Structure: Market Model Industry Registration File 1: Market Model Ind MK1 M1 5 MK2 M2 15 File 2: Market Model Reg MK1 M1 50 MK2 M2 150 I have to merge tthese 2 files and store it in the above table. I have tried merge and just got 0 in the Industry ...

Incase If I have multiple headers in the file, I think this logic will not give expected result.