DSXchange

Thanks Ray I followed up on your advice and I am not sure now Based on the output below I still have 18.6 gb space available on that mount Also I am reading a flat file with about 5 million rows. That is my reference link to the lookup. What does it copy that again somewhere in the dataset folder Pl...

Hi I am getting the following error message BSISLkup,0: Could not map table file "/usr/IBM/InformationServer/Server/Datasets/lookuptable.20090204.wjqwela (size 3903356896 bytes)": Not enough space BSISLkup,0: Error finalizing / saving table /tmp/dynLUT311374819e6bad I read the forum for AI...

Hi I am creating a text file which has one column to be Decimal (15,3) The file gets created okay but when I read the file again it rejects about 400 rows with an error BSEG,0: Field "BSEG_MENGE" has import error and no default value; data: {20 20 20 20}, at offset: 166 I have a reject fil...

If I want to build a transformer contraint as below should I be using one transfomer for each of these contraint or can I throw all of them in one transfomer Also how does one escape a double quote character ...for example if I want to check for existence of IMPERIAL COLLEGE - "ACTIVE ACCESS&qu...

This is what I found out For information Analyser you can setup user in the console without needing any datastage users ( and may be that is what you meant.. sorry if I misunderstood your response) For datastage and qualitystage user setup for most part we still have the pirmary model of 7.5.x under...

I have configured our test environment for now to use the IIS user registry but in the process of setting the security and roles, I had to assign ds users which is even it raised my above notes

I have some questions on the security model in version 8.x.x The security model that focuses on IIS user registry It is my understanding that if one elects to use the IIS user registry then ONE CANNOT SHARE it with the websphere user registry. That means security credentials have to be mapped on a u...

Thanks, I have edited so it is not bold anymore

Any suggestions for my real problem

Sorry about the Bold characters. My apologies,I only intended to questions to be bolded but must have missed the ending tag /

<B>How was the source file created?</B> Thanks Ray. The Korean customers gave us a excel file with sample data 1) the excel sheet was saved as unicode text.( tab seperated) 2) The unicode.text file was converted into a utf-8 encoding using .NET classes 3) The new utf-8 file was read by datastage job...

I have a Information Analyzer issue. The data is from Oracle table and is Korean characters stored as UTF 8 in oracle table When I import the data in excel it looks Korean as normal ( 3rd column below is NAME field) 1 100 대표 2008-12-18 08:56:54 1 101 안중태 2008-12-18 08:56:54 1 102 천정균 2008-12-18 08:5...

Thanks Ray and sorry for responding late You are so right in that unicode is not UTF-8. Apparently when you save it as unicode text in excel, windows word recognizes it and then we used a utility writtin in .NET to convert it into a UTF8 format Once it is in UTF8 format and set the NLS map and loade...

Hi I have a sample excel file containing 10 Korean customer master records. The data has korean data which is visible when we open the file in excel We save it as a unicode.txt file. When I try to update the Korean sample file and try to loaded it into DB2 wtih UF8 chaterer set, then should the data...

All our files we want to profile will be either .txt or .csv made available under the unix path /cdwdata/source/temp

Thanks to this forum and your help Ray I saw some postings about QETXT.INI I copied the following in there [Defined Tables] customer.txt=CUSTOMER [CUSTOMER] FILE=customer.txt FLN=0 TT=FIXED Charset=ANSI DS= FIELD1=CUSTOMER_ID,NUMERIC,3,0,3,0, FIELD2=COUNTRY_CODE,NUMERIC,3,0, 3,3, FIELD3=CUSTOMER_NAM...