DSXchange

ray.wurlod

There are no limits on the number of columns that DataStage can import. The importer has reported that it found a table with no columns. Do you have sufficient privilege, as this user, to view system tables?

ray.wurlod

Is /ascential/DataStage/Projects/advprod/sokZqlaa/err a file? If so, what's in it? (I'm thinking it might be an error log containing extra diagnostic information. I could be off target there.)

ray.wurlod

Boston is also one of the busiest cities for Informatica. Guess there's a lot of ETL happening there!

ray.wurlod

Look at any ASCII table. There's one in the DataStage BASIC manual (Appendix B). Numeric characters sort ahead of alphabetic characters. Upper case letters sort before lower case letters. Char(48) is "0", Char(65) is "A", Char(97) is "a".

ray.wurlod

The "official" answer - the one that you have to parrot to pass the MS certification for NT Administrator - is that WinNT requires 16MB.

ray.wurlod

That it's BCI.Put indicates that it's an ODBC or UV stage. Since the message is from DB2, we must assume the former; you can't get at a DB2 database through a UV stage! There's more to this error message. We need to see the response from the database server, and we need to know what error code -805 ...

ray.wurlod

Time zones, guys! I'm working in India this week (GMT plus five and a half). Go figure.

I think I would have guessed at the incomplete project installation, and would have reminded everyone to

Code: Select all

SELECT * FROM SYS.MESSAGE WHERE @ID = '081002';

ray.wurlod

Just the sheer possibility that you might miss something. What's in all those other Repository tables? The design-time information as well as the run-time information? What records ought you not to be removing? What about hashed files in non-project directories? System table entries for any UV table...

ray.wurlod

You can update a hashed file (whether or not it's cached) quite easily. If the update needs to occur to the hashed file (output constraint on the link writing to the hashed file), the design looks like this. HFStage_1 HFStage_2 | ^ | | v | -----> Transformer_Stage_Checking -----> On the link that pe...

ray.wurlod

Use alias names in the derivation SELECT ProductType.CODE AS ProductTypeCode From ProductType; SELECT ProductName.CODE As ProductNameCode From ProductName; SELECT FundType.CODE As FundTypeCode From FundType; You can do these in the Derivations field in the Columns grid; then inspect the generated SQ...

ray.wurlod

Ahh, the 1NF mind!

You can label the breakpoints. Should have done that.

Code: Select all

SELECT LNAME, FNAME, BREAK ON "'Sub-total 'V" STATUS, TOTAL AMT_OWED 
FROM TempUVtable 
ORDER BY STATUS, LNAME;

ray.wurlod

UniVerse SQL has a BREAK ON clause that allows you to capture summary rows after each set of detail rows. Using an intermediate UV stage, insert all your rows into the table with regular inserts. On the output side, which will be feeding your text file, use user-defined SQL something like this: SELE...

ray.wurlod

For the third and last time, don't do it!

ray.wurlod

You CAN do this within DataStage! The Sequential File stage (version 6 and later) supports the idea of streaming the data through a filter command. They had zip/unzip in mind when they first created it, but there's no restriction. The stdout of the filter command becomes the stream that is read by t...

ray.wurlod

If you delete the entire contents of the directory you're also taking out the software - what you called the "default conmponents". Further, there are administrative entries in the Admin (UV) account and in the SQL Catalog, as well as secondary indexes already mentioned, that would need to be repair...

Search found 53125 matches