DSXchange

Hi, SEQ FILE --> ORACLE TABLE SINGLE COLUMN (sql type Integer, length 10) I have a seq file which reads data from dat file which are IDs ( 81001, 81002 etc). The SQL Type is Integer of length 10. I am able to view the data. This is directly inserted into a oracle temp table with "INSERT INTO ta...

Hey Ray, Appreciate your reply Sir. Yes, I had used http://ipaddress_of_my_linux_box:9080/index/login.asp. I get the same error as stated above "/index/login.asp has not been defined.". I am able to ping to the server from the client. I can attach the systemout log file if needed. Donno if...

Hi, I had installed WebSphere 6.0.2.27 and installed Datastage 8.1.0.0 on a Linux box. I am able to open the websphere web admin console using port 9043 but I try opening the isadmin web console, I get a "SRVE0017W: A WebGroup/Virtual Host to handle / has not been defined." error. This is ...

Hi, I had installed WebSphere App server V6.2.0.27 and started on the install of Datastage Server V8.1.0. I selected Engine, Services and documentation during the install and I have a Oracle metadata repository which am using during the install. Initially, I got a NLS error (FDataStageServer 35534: ...

Hey Kim, Here is what I did .... 1) flat file --> hash file (hash) 2) UV stage (used metadata of hash) --> joined to transformer in my main ETL.. 3) selected 'User-defined Query' and went into into SQL-query tab. I found two-windows, one for 'primary inputs' and the other for 'reference inputs'. I b...

Kim, I am sorry but I could not get the gist of your explanation. If possible, I would be grateful if you could give me clear understanding in logical steps of how to use your solution. Let me put my logic in easier sense.... if hash.x = input.x and input.date >= hash.dt_lo and input.date <= hash.dt...

Hai friends, Thanks for your prompt response. I cannot use a single key for the hash file since the user's who gave the data informed me the same. So, considering that I have to use ranges and cannot go with single key, 1) Can I consider using an OCI 9i stage in place of hash file and go for a user ...

Hai, This is condition I have to use.... if input.x = hash.x and input.date >= hash.low_date and input.date <= hash.high_date then hash.y else 0 If i am right, I cannot use a hash file to do the above condition. I have to go for a DRS table and use the above query. I need some help in knowing how/wh...

Guys, I appreciate everyone who has responded to my query. I could clear my problem. The solution is, I need to use 'trim(left(input,12))' in the key expression under hash.y field. Now, the hash is read correctly. I understood now that the number of characters in the key expression and the field sho...

yes, I can see the data in the hash file and the keys match. as part of the debugging, I am using constraints in output and error files. for output, the constraint I am using is NOT(hash1.NOTFOUND) for error output file, the constraint is hash1.NOTFOUND when i ran the ETL, all the rows got into the ...

hai chulett, I used this expression in my output which is .... if hash.NOTFOUND THEN 1 ELSE 0 and the result returned a '1'.. Does this mean that the hash file has null values in it? if so, what would be my next step in the process to debug the issue... I appreciate you time and precise response... ...

I tried to pull the hash value directly into the output and also gave a constant value to the output.

The hash file is not read at all. The output shows 0 for hash file input and the constant is showing in the output.

-Raj

I am using the Hash file as a lookup only. The input I am talking about is from the source.

-Raj

Hai Arndw,

For that reason, I had changed the logic to use the key x also....

if input.y = hash.y and hash.x = constant then hash.z else 0

This also does not solve the problem.

Thanks for your response,
Raj

Hai Let me make my question easier and clearer. I have 2 keys x, y in my hash file ( the columns are x,y,z). The condition I am using in the output field is if input.y = hash.y then hash.z else 0 The key expressions I used for x, y in hash are a constant and input.y respectively. I tried all the kno...