DSXchange

I've used LONG and created the table also.Now i have database as a source file and a database lookup as reference.My reference lookup has total 304 rows and i have selected only one key here as k2.But there are so many duplicates key.For e.g: k1 k2 Text_Id Key_1 Text_Name Key_1 Term Key_1 But my out...

Craig as you've said to load data into the database i've done for the input source of hash file.But for the source of job2 i'm not able to create a table in oracle 9i of a single column of length around 50000 and datatype is CHAR. How can i create a table of a single of around 50000 and CHAR datatyp...

You're right kcbland, my hash file has only 1:1 reference. I have two jobs: 1) In job1 one i'm creating a Hashed file with source as a sequential file. There i have two columns say k1,k2. To fetch the complete set of records from input i've set them as keys k1,k2.If i set k2 as the key only i'm not ...

Thanks ray for the correction.

Can you please suggest any other possible way to do it.

I have a text file as source and hash file as reference.
The key fields in hash file are k1,k2.
But in source file only one key field is present i,e. k1.

How can i join the hash file with the source file?

Please help me out..

It's coming because of the default Quote ' " ' character present in the output file.
In format tab give quote character as '000'.

I think this will definitely resolve ur problem.

Thanks a lot..
I've used that code but still same character is coming.
Since the 'new line' character is coming at the end.
I trimmed like this "Col_Name[1,Len(Col_Name)-1]"

It's working now..

Anyhow thanks again for the help..

Thanks Chulett for the help. But still i'm not clear. Can you be more specific.. What's that LF,code and char(10) ? I think i didn't given the clear picture.It's given below My columns last character has newline('\n') but it appeared as some unusual character, since i've JPN-SJIS character set.And m...

Sorry to all.

I found some unusual character at the end that's why the data is not matching.
I've used Trim for that.

Thanks for the help..

My project has JPN-SJIS character set.I'm reading a .csv file.When i view the data for the last columns have one unusual character at the end. When i pasted it in text editor i found it as new line. I want to trim this "new line" character, and my columns has variable length. How can i do ...

I have one input file of only one coulmn say "single_column" around 30000 length.It has around 1000 rows each identified by a unique key. I'm using a hash lookup file as a reference which contains the keys, it has around 400 rows.My job ran successfully but there are no rows coming from th...

As Arndw said you can do it by using logical "or" operator. Take your ouput as hash file and use the same hash file for reference in the same job. Then take 4 stage variables for Date and Row_cd. E.g: Pre_Date->HshFile.Date,Curr_Date->SeqFile.Date lly for row_cd. Then take one temp stage v...

Yes Arndw it's a warning but my character set is "JPN-SJIS"

Yes Arndw it's a warning but my character set is "JPN-SJIS"

The error i got is

"Src_ActsPtyF_DrpFld_En..sActsPtyFItemSectionDrpFldEn_MrgWrk1.ToActsPtyFItemSectionDrpFldEn_MrgWrk1: nls_map_buffer_out() - NLS mapping error, line 90 (rough estimate)"

NLS in our project is Japanese i,e. "JPN-SJIS"