DSXchange

SCD is a regular stage type, it sits right there in the processing stream.

Presumably some non-zero value.

What other rights does that person require? Is the receiving project a protected project?

Use the "Before SQL" tab to add your TRUNCATE TABLE (or ALTER TABLE TRUNCATE PARTITION) statement. Or use the "truncate then insert" option if the stage type supports it.

If the Partition Table field is populated, the stage is able to use parallel read.

Welcome aboard. You can often get your answer faster using the Search facility in the menu at the top of this screen.

No.

The information is in the export file but is not brought into the receiving Repository. If you can identify any object that was imported you can find out by whom and when the import occurred from the DS_AUDIT table, and ask that person about the provenance of the export file.

What is your definition of "performance" in an ETL context? Without knowing this it is not possible to answer your question. And what would be your alternative if the answer were to be "yes"?

Capture the output somehow and work out the line number in which your desired output appears. For example if it's line #3, use to retrieve the result.

How wide are the records (not 53 columns, but how many bytes)? What else is happening on the system at the same time? How much elapsed time (and rows/sec if you must) does the Standardization stage report in the Monitor? What is the total volume of data processed? Please describe the entire job - th...

Version 7.5 is the current test. I spoke with Gene Salos (who looks after these things) at IOD 2008, and learned that QualityStage version 8 will be "the next cab off the rank" in released certification exams for the InfoSphere range of products, though he was unable to give me a date. Probably firs...

It did used to be true in early versions but was fixed/changed, if I remember correctly, about version 4. You had to validate the job to create the hashed file "automatically" before that.

You have to find out where there is an input record that has two many fields - possibly because there is a delimiter character in a string-type field. The error message gives you the row number where it occurred.

The significance, of course, is that you can create hashed files (note: it's not "hash" files) when the job runs. One of the options is the ability to delete any existing hashed file of the same name in the same location before re-creating it.

You will not need Metadata Workbench. Impact analysis is provided through the metadata analysis service of Information Server.