DSXchange

You should be able to use the same dictionary but, when you provision the rule sets, two copies of the .DIC file will need to be made on the server. So, even if you have one copy of the file plus a link to it on the client, this will not be the case on the server. Therefore you may as well make a co...

By any of the mechanisms for starting jobs. Perhaps you can generate an invocation ID based on the time of day.

Just mark the column as "Type 2 change". You will also need some way to identify the expired record - either a date or a flag.

Sudheer, please strive for a professional standard of written English expression on DSXchange. In particular do not use SMS-style abbreviations. DSXchange is not a mobile telephony device, and such abbreviations make the already burdensome task of understanding English even more difficult for those...

So your client has the CD. Get them to make the samples available. That way no-one violates their license agreement.

Yes, IN THREE ROWS. And then only if you've enabled multi-row return.

Please post your reference key expression - copy it from the transformer stage and paste it here.

OK, you look up using "A" as the reference key expression. You get back 101. You compare this ROW BY ROW to determine whether there is a match. You can NOT get a single row output from this. Downstream of the Transformer stage you need to perform a "vertical pivot". Search the forum for "vertical pi...

Table definitions are stored in a table called DS_METADATA.

There are many different record formats used in this table, depending primarily on the source of the table definition.

It's a subshell, not a DataStage process.

If you want to have nullable columns then you need to handle this condition explicitly in Transformer stage expressions. If IsNull(DSLink5.name) Or IsNull(DSLink5.value) Then SetNull() Else If DSLink5.name="input1" Then DSLink5.value ELSE ""

Yes? What is it? The constant "A", the value of MT_MODELNUMBER, or the concatenation of both and, if so, with a space between or not? You see, in your specification you provide two column headings and three values. If you're that confused imagine how much worse it is for someone else trying to under...

Can't be that urgent - six hours have already passed without further response from yashpalreddy.

This looks like a singularly cumbersome design. How many lookup keys do you have? What are the reference key expressions for it/these? Combined with the result of whether or not the lookup was successful you should be able to generate the required output as an output column derivation in the Transfo...

What's the rush? If there is dis advantage or even dat advantage, things won't be any different tomorrow. We don't do "urgent" or "asap", especially on weekends. If you need rapid response sign up with your support provider for express service and learn just how much "urgent" costs. DSXchange is an ...