DSXchange

Dump the data to a text file, and there examine it with a hex editor such as UltraEdit. ... Ray, I have used ultaedit and when checked view line endings it was displaying at the end Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add 3 Build 1 dx add ...

Ray,

I'm not sure of what delimiter it is .I have tried by looking at the data.

Is there any way to figure it out....sorry for this kind of question ...

Hi, I have a job db2...>trns...>seqential file.I'm extracting data and populating into a file.Source has 2 rows but when populated into file the file count is 10. I have used CONVERT(char(010),char(032),trim(fieldname)) in transformer to replace new line with space..but it is not working.... data is...

Thanks

I found that it stores in SDKsequences and VOC file.

Hi, In an existing job ,it uses KeyMgtGetNextValue('seqABC') in a tranformer .The job is working fine in production too. My doubt is where from seqABC comes from.I have searched through the jobs and was not able to find. Can anyone of you please let me know where i can find this .Where this may be s...

Ray,

i'm creating a file with 4 columns.

col1 VARCHAR2(15 ) ,
col2 CHAR(2 ),
col3 NUMBER(8),
col4 VARCHAR2(5 ).

Should i create 64 bit addressing ?

Chulett..in production we are using production files.

In test without making changes i have used the exported job which uses dev files.

I have generated hash file in dev account.

I promoted my code to test environment.I'm able to access the same hash which i have generated in Dev account.

Will there be performance impact when accesing a hashfile from dev account in Test .

Hi,

I have a job where i need to access a hashfile as lookup.

Will there be any affect when we access a hashfile created on dev project from testing project.Both dev and test projects are on same server.

I'm trying to load 3 lakh records to hash file.

Please let me know.

Thanks in advance!

Hi, I have two jobs. First job load data from a table1 to hash file. In second job the hash file is used as lookup. My doubt is in some jobs when i run the second job the first jo is internally called.Where as in some jobs the first job is not called internally and it gives wrong results. How can we...

Hi,

I need to generate a file with coulumn names like

Date Report Produced and Country, if not USA

I have only 3 stages in job.I have i/p csv file and transformer and sequential file.

In transformer is not permitting me to do this.
Is there any possiblity to do this .

Thanks in advance.

hi,

What languages does datastage support or can invoked from datastage?

Does it support COBOL,JAVA ,C++ etc

Thanks in advance!

hi,

If we are asked to design a job given with a scenario how to decide whether we should go for server job or parallel job?

What are the essentials in considering server or parallel job with respect to both unix or windows platform.

Thanks,
sravanthi

Hi all, I have a scenario where i have to give different paths for the same columns like: <DescriptionData> - <bullet_point> <value>col1</value> <value>col2</value> </bullet_point> </DescriptionData> - <AdditionalData> - <target_bullet_point > <<value>col1</value> <value>col2</value> </target_bullet...

Hi I have a scenario where i have to pass the value of a column as tag dyanamically. ex: name values(abcd,xyz) id values(11,22) expected output should be <work> <abcd> 11 </abcd> </work> <work> <xyz> 22 </xyz> </work> I have given tags as : /root/work/@name /root/work/value/text() I'm getting the ou...

try multiplying with 1 and see if it works