DSXchange

Hi, I have a simple job Oracle Enterprise stage ---> modify stage --- >lookup with Oracle enterprise stage --->transformer--->oracle enterprise stage The lookup runs really slow. The join is on one dummy value of 1 to fetch one value from the reference table. I can see the data tricle well till the ...

Hi All, I have scenario wherein i have to perform lookup with one table one multiple conditions. For example: Source Table ====> A Lookup Table ====> B Perform lookup on the table based on B.Col3 = 'CC' and A.Col1=B.Col1 to and fetch B.Col2. Similarly, next condition is on Col3 = 'FF' and A.Col1=B.C...

Thank you!! Will code and post if resolved.

Hi All, I have the following requirement and have to design a job to meet the same. The source Table A has to load target Table B with hierarchy information. For Example Table A Parent Column Child Column 200 100 300 200 600 500 800 700 1000 900 Table B Level_1 Level_2 Level_3 100 200 300 500 600 70...

Hi,

Please help in converting a source field of datatype NVarchar(120) Nullable to target field of decimal(120) Not Nullable using a modify stage.

Thank you.

When i use the character set you mentioned I do not get the warnings. This ensure datastage is reading the records fine. But when the data gets loaded to the final oracle table I see some special chars loaded in place of these characters.
Am I missing something here?
Please advice.

Thank you for the reply.

I searched online and found the following details:

Raw encoding: 0x81
UTF8 encoding: 0xC2,0x81
Description: (Undefined)

Raw encoding: 0x8B
UTF8 encoding: 0xC2,0x8B
Description: (Undefined)

How do I resolve this issue?

Any inputs for this post.

Thank you so much it worked with ''.

Yes did it but does not work. It yet reads only 2 rows..

[quote="vivekgadwal"][quote="devidotcom"] Col 1, Col 2, Col3 1234, "DATASTAGE1",2345 1234,"DATASTAGE2", 1234,"DATASTAGE2", 1234,"DATASTAGE2",2345 The job fails to read the row 2 and 3. Please help Thanks[/quote] Do you have the Col3 as empt...

Hi All, I want to read a file with the contents below. All the three columns are nullable. What will be the null field value to be given to read the null columns? Here the first line is the header column names. Col3 is nullable with no values given to the row 2 and 3 Col 1, Col 2, Col3 1234, "D...

Thank you Ray.

Hi All,

I have a small check to be done on the customer name column (Cust_Name) to term it a valid name value.

This column can have
1. Only letters in upcase (A-Z)
2. Numbers (0-9)
3. Can contain only these values (& . ,)

What is best way we can handle this.

Please let me know.

Thanks
Devi

Thank you all... I too cleared the certification... with a good score.