DSXchange

Pls anyone let me know the further process??

By,
RAJa

Thanks for your help. But I don’t find that file anywhere in my UNIX box. Can you please let me know how to proceed further?



Thanks for your assistance

Raja

We are not able to connect to Oracle using ORACLE or DRS stage. Following is the error message: ##I TFCN 000001 17:36:36(000) <main_program> DataStage XE Parallel Extender V7.0.1 Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc. All Rights Reserved ##I TUTL 000031 17:36:36(001) <main_program>...

Hi, We have a small issue in loading the fact table. We are getting null values in certain dimensions like vehicle and driver, but when Amruta checked the same with Shabber, he said, that is a valid record, and we need to take that row into account (need not through in to reject). Following are the ...

Hi, We have a small issue in loading the fact table. We are getting null values in certain dimensions like vehicle and driver, but when Amruta checked the same with Shabber, he said, that is a valid record, and we need to take that row into account (need not through in to reject). Following are the ...

Hi,

Loading the data from transation table to Fact table, hash file is used for Lookup.

In transaction table one field having the Null value. This value i want to lookup with hash file.

How can i do?.

Hi, I am transferring 150000 thousand rows from source to stage, using direct map (Both Oracle DataBase on HP-UNIX). Data was transferred, but job was aborted. When check with Director getting the below error. Abnormal termination of stage JSTG05TRNEBL1…. Detected Let me know why this error occurs!!...

Hi!! I am transfering the data from source to stage. The above stages are resided in Oracle 9i database. When i am using direct mapping oracle(Source) -> Transfoemer -> Oracle(Stage) getting the below error. Abnormal termination of stage JSTG01B2C602.. detected. Source volume of data 158000. Kindly ...

Hi,

Row Merger - Merges all the columns into a single string of a specified format

Insted of this we can use string concatinations also. Why need this stage and when will chose this one.

Let me know in the Rowmerger Multiple line options.
By,
RAJa

Hi, SequentialFile->Stage->General having two check box. 1.Stage User Named Pine 2.Stage User Filter Commands. The second options could't able to understand based on the help and tell me where and which situations can use?? HELP ------ Select this if you want to specify a filter command to process d...

Hi, In Row merger stage, when i am using Multiple lines option getting some errors. Data was tranferd,but when open the View data showing some formet. I could't able to understand. Pls let me know, 1) What is the purpose.. 2) How can i use some example? 3) Tell me situations where will use?? By, RAJa

ray.wurlod wrote:It defines a string with which NULL is represented in the data stream to be transferred via FTP. For example, the remote file might represent NULL as the string "<NULL>".

Can u give me an example how to pass Null string

Hi,

Can anyone explain what is the use of NullString Properties in FTP Plug-in Stage .

By,
Rajendran.

Hi,

i have doubts in Static & Dynamic hashfiles.

- What is the difference between this two types.
- When should use Static & When should use Dynamic.

by,
Rajendran.

If you do a search Ray has covered this. There are certain databases which can embed a table. Universe and UniData are probably the most common besides the COBOL files. In COBOL these are called repeating groups in Universe they are called multivalues with controlling and dependent associations. In...