DSXchange

HI, I have created host computer name(TEST) as well as Datastore in last month and also imported some files metadata. Now i am trying to import metadata and getting warning as "AGENT CONNECTION ERROR" . This warning getting at "HOME -->cONFIGURATION --> SOURCES --> CLICK ON HOST COMPU...

Yes, Microsoft Excel only.

Hi,
How to read XL files into IA(V8X).

I have worked on fixes width files as well as comma saperated files. Today i got few XL files.


Can so one help me on this.

Thanks in advance.

Venki

I am using Information Analyzer (V8.0) only.

Can you please explain how to specify XML metadata into QETXT.INI file.

I have knowledge to specify fixed width files metadata (fileds) into QETXT.INI and import same into IA.

Can any one please assist me on this?

Thanks in advance


Regards,

Venkat.

-------------------------------------------------------------------------------- Hi, I have another reqirement. Now Source file is XML. How to read XML metadata into PROFILING. I have an idea of reading flat files, for this we have created .txt and QETXT.INI files in particular folder. Like that how...

Hi ,

Thank you..

If i remove First line (header) and Lastline (Trailer) from the file, then it should be FIXED WIDTH file.

Please some one correct me if i am wrong?

Hi,

I have another reqirement. Now Source file is XML.
How to read XML metadata into PROFILING.

I have an idea of reading flat files, for this we have created .txt and QETXT.INI files in particular folder.
Like that how to read XML metadta.

Can some one help me....


Thanks in advance.

I have solved this problem,

This offset should be the STARTING position of the field name.

For E.g,
02ven1234123456yhhhyyuui

Field1=IND,VARCHAR,2,0,2,0,
FIELD2=NAME,VARCHAR,3,0,3,2,...

Hi, I am new to PROFILING, Now i am preparing QETXT.INI for fixed width file. My query is how to specify OFFSET for each field. Eg:- My file structure is 02T20 2034UKLUN02458632 FIELD1=IND,VARCHAR,<Precision>,<Scale>,<Length>,<Offset> Can any one have idea how to specify offset of a perticular field...

Hi, I am new to profiling.. My source system is FIXEDWIDTH file. This file structure is , 00123420090218 01234446venkgfftyhh123bbh 123 T02 01234447cenkgfftyhh123bbh 123 T02 01234448dbnkgfftyhh123bbh 123 T02 01234449aenkgfftyhh123bbh 123 T02 991234004 In which 1st line is header (start with 00, singl...

sequential file stage. ... Hi, I have modified job with Sequential file stage, Job Strucure is : Sequential File Stage-->XML input Stage-->Dataset/Sequential file stage. But this job is getting aborted and giving following error message:- APT_CombinedOperatorController,0: Fatal Error: Fatal: XML in...

Hi, Tryiny to import an XML table defination using XML Tanle Defination option ,it is throwing err " Common Language Runtime Detected an invalid programme ". Thanks in Advance! :wink: Actually xml tables meta data is available into xsd files. use xsd file inport metadata from xsd file.Als...

Generally this type of warnings gives when incoming field length is larger than the outgoing field length.
some where small missmatch occured between incoming field length and out going field lengh.
Check once more.
Regards,
Venkat.

As u said i think the Oracle stage with 3 colums is taken as lookup, thats why you r getting null values Apply proper partetion before take lookup and check once again another small question, the datatype of data field is DATE or TIMESTAMP, You posted this date field with datatype Decimal 15, I thi...

ArndW wrote:looks like the disk is full if all users are now affected. Have you tried checknig with "df"? ...

Can you please provide full commond?

Thanks inadvance
Venkat.