DSXchange

Connection is closed. What's unclear about that. The network fell out from under you, or processes stopped communicating. Find out why and where.

The second person personal pronoun in English is spelled "you", not "u". I find it offensive to be addressed as "u" in any format. Until you confirm your version, we can not help you further. If you're on version 7.x you will get a ProfileStage answer; if you're on version 8.x you will get an Inform...

You're not on version 4. Please advise correct version. This will affect how the question is answered. Essentially your file structure and file definition do not match.

Is the prompt perhaps "login: " rather than "login"?

Welcome aboard. There's nothing "out of the box" but you will observe that the file names are in identical format, so you can compare them as strings. This is a major bonus. Get a list of the file names (say using a DIR command). Strip off all the lines that are not file names, then use the Max() fu...

Your knowledge is out of date. In version 7.5 compiling the Transformer produces an operator, which uses exactly the same "interface" as all other operators.

Designer.

Click the tool that looks like the Internet Explorer icon and it will produce that report for you. Preserve the intermediate XML and you can go wild with extracting precisely what you want from that.

As much as possible, in parallel jobs, we strive not to use internal storage (that is, not to touch data down to disk), as this slows things down. The structure of data in memory is given by the record schema that you can see in the generated OSH and the score. The same structure is used in Data Set...

I notice that you are using version 8.x.

You can also use the Resource Estimation tool, based on a 100% sample, which will give you immense amounts of detail.

But it's the wrong answer. A surrogate key preserves uniqueness, nothing more. When you need to preserve history, such as to be able to track a person's name or address changes, then the primary key of PersonID alone won't do it. You'd need a primary key made up of PersonID and some way of identifyi...

In parallel jobs you don't really have hashed files readily available.

"ISO8859-1" and "ISO-8859-1" are not the same string. You probably need to copy the ISO8859 entry in oracle_cs.txt and insert the hyphen, so that ISO-8859-1 is also mapped to the NLS_LANG value WE8ISO8859P1.

There's always dsrecords for the counts, but nothing for all the other stuff.

And what was your reply?

Have you searched here, Google, Wikipedia and/or The Data Warehousing Institute (to name a few) for the rationale of using surrogate key in Type 2 SCD?

If using a sequence, you do NOT supply a key value from DataStage. Therefore the only column passed from DataStage should be the non-key columns - do not have TSNO in the Columns grid.