DSXchange

i can't find the syntax to add default value in schema file. can you provide me an example.

how would the line looks like?

thanks again.

thanks, RCP is turned on. yes, I can use the dollar_cd field in the transformer now. But when I try to use another column from the schema file, I have an error saying "Field DOLLAR_AMT has import error and no default value". DOLLAR_AMT field is decimal[38,10] What I did then, was going to ...

I have a job that uses a schema file in the sequential file stage. It is all working in terms of loading the file correctly into the database. job flow: Sequential File -> Transformer -> Load database schema file has a field called dollar_cd. I need to use the dollar_cd field inside the transformer ...

I have a simple job that flow like this. odbc enterprise stage -> transform stage -> load to target table. I have 10 tables with different columns to load to 10 target tables, using the above logic. There is not much happening in the transformer stage, except to add current date time. All the input ...

thank you.

I have a string "201009" which is YYYYMM format.

I need to convert it to two different formats:

Sept, 2010 and September, 2010 to be used in report titles.


Can someone show me how in the Transformer stage ?

thanks!

ok, I made some progress and like to share with others. On window: 1) open odbc and set up a dsn point to my excel file 2) I have one sheet in the excel file called mappings 3) open the excel file and define a name range. In datastage: 1) use ODBC stage 2) under properties, Connection: Data Source =...

I did step 2 in Excel to create the range name. But still can't read it as table name. Error message was object (which was the table name I use) not exist.

I can import the table definition, but I still can't use odbc stage to read the worksheet yet.

thanks Ray.

I can now import the table definition with your advise.

Can you tell me which stage to use to read the Excel file. and how to set it up.

thx,
-aggie

I have an excel workbook "myworkbook" with two sheets, namely regions and mappings. And I have been trying to read the mapping sheet in datastage with no success. note: Because the excel file contained Chinese characters, I was not able to save it as csv file, which changed all the Chinese...

Hmm, that's what I have, although I prefer a Unix base server. The thing is, I had it working on a different pc which runs xp prof. Now I have a faster machine, so I want to reinstall datastage on it. But came to a small issue, when the domain server was not showing up on the Credential listing. any...

I have installed Datastage 8.1 on a virtual machine running Window XP. After the installation, I was able to logon to the Web server. But when I tried to setup Credentials, there was NO domain listed. Not even the server that I installed Datastage on. Can someone help, I don't know where to look nex...

I tried to have a good understanding of Run Time Column Propagation (RCP) in term of when and how to use it properly. Under what circumstances would it be a good idea to enable RCP on the project level? What are the downside for enabling RCP at the project level. When not to turn on RCP at the proje...

I have been using datasets with the lookup stage. But then I read about the fileset lookup stage. What is the difference between using one master dataset, and one reference dataset and a lookup stage to join on a key versus one master dataset, one fileset lookup stage, and one lookup stage to join o...

thanks raga.

can you elaborate on option3, I have not used it before. I am keen on this option.