DSXchange

It's my understanding that line terminators are required. You'll need to pre-process your file - perhaps using DataStage - to add them. ... Hi Ray, You are aboslutely right. I have gone through the manuals of Data Direct drivers and have found the following information regarding Fixed Length files:...

Your file definition for "CUSTOMER" should be coded as FLN=1 TT=Comma lstasaur, lstsaur, My file is Fixed length and not comma separated so I can't put 'TT=Comma'. In regard to FLN it means whether the first line contain the column names or not. Value 1 indicates that the first line conta...

Although I have marked this topic resolved but I am re-opening this topic because I am facing a new issue with the Fixed-width file. In my earlier scenario i was having the files which are fixed width but with end of line character after every record but now I am getting fixed width files without an...

Problem has got resolved. The QETXT.INI for fixed width was getting created incorrectly using the Define tab of the Text driver on Windows. For the above data file the QETXT.INI should have to be in the following format:- [Defined Tables] customer.txt=CUSTOMER [CUSTOMER] FILE=customer.txt FLN=0 TT=F...

Hello everyone, We are profiling the Fixed Width Ascii files but even after defining the schema in the QETXT.INI Profile Stage is only reading the first field and rest other fields are takes as null. Sample QETXT.INI file [Defined Tables] customers.txt=CUSTOMER [CUSTOMER] FILE=customers.txt FLN=1 TT...

Thanks everyone for all your replies.

My Client is now getting in touch with IBM guys to confirm about the countries supported, refresh interval and some other specific questions about the project.

Thanks everyone for giving the reply. But now I have few more questions:- 1)Can the CASS Add-on be used for other countries as well such as UK and Canada or is it specific to US addresses only. 2) Is the CASS Add-on database going to be regularly updated for the new addresses and after how many days...

Hello Everyone, I have joined one of the client location as a consultant and my client is trying to propose Quality Stage as one tool for their requirements. Their Requirements are as follows:- 1) Address Lookup e.g. if the House number and post code is provided then it should return the complete po...

lstsaur wrote:dsusr,
Yes, you must define each file in your QETXT.ini file. Also, you have to apply the Rollup10 patch.

Thanks for the reply. But Can you please tell me what is this Rollup10 patch?

Regards,
dsusr

Hi Ray I would prefer to move the files to a unix machine instead of using the samba or LDAP technology as I dont have strong understanding of both these technologies. Currently my PSDB or IADB is on the same machine that have analysis server i.e. my HP-UX machine. I was just going through one of th...

Thanks Ray for providing this information but I have some questions on DSN creation. Currently my Analysis server is on HP-UX and the files are present on my Windows XP machine which contains the Information Server Console. Now at one point in the manual it is written that the DSN for for source DB ...

Hi All, I have a requirement to do the complete profiling ( Column Analysis, Table Analysis, Primary Key Analysis, Foreign Key Analysis and Cross Domain Analysis ) of customer data which is provided in Flat files using Information Analyzer. To Start with I have following few questions:- 1) Can we pe...

Sorry at the first instance I didn't get your question and thought that you are doing something else so have asked the Osh code. But now for your problem you will have to apply a logic in transformer after the sort stage to check if the previous record has same key and value. If yes then exclude tha...

Can you please post the orchestrate code for this ????

[quote="kcbland"]Are you using NLS? ...[/quote]

Could you please explain the reason why it can behave with NLS enabled because in the guides it is written "avoid using ICONV/OCONV when NLS is enabled unless you fully understand the consequences"