DSXchange

When trying to use the Import/Export Manager I get the error "MSXML Parser 4.0 is not available". This is followed by "ERROR: DAPIGUIWrp::runDecoder() failed. Can't run decoder." Is MSXML Parser supposed to install with Foundation Tools, or does it have to be downloaded separately?

Oddly, perhaps, this is not an Informatica forum!


I can't imagine how it could be valid. "I have something in my right hand and something in my left hand. You can not see them (to you they are unknown, or "null"). Are they the same?"

I guess you need a Promote Subrecord stage in there.

This is the correct format. The braces are added by the data browser; they are not actually part of the data, but are indicated by the metadata (record schema) in which subrecord is indicated.

suryadev wrote:... also I cannot see any solution in the post...

You need to obtain a premium membership to see the entirety of the five Premium Posters' premium posts. There's a membership link from the DSXchange home page. Premium membership is not expensive; less than 30c (Rs12) per day.

If the source contains NULL then you must handle that - the result of a stage variable can not be NULL. Therefore a solution that handles NULL satisfactorily is as follows. svField2 = If IsNotNull(InLink.TheColumn) Then Field(Field(InLink.TheColumn,"|",1,1),",",2,1) Else "XY...

That is all correct. What you can not do is allow xyz to contain NULL even if it is marked as nullable.

col1, col2, tarcol1 and lkpval must all be nullable.

How would I know? You pass the value you want to look up, and link it to the field in which it is likely to occur in the reference data set.

Load the environment variable as a job parameter. Then you can change its default value and, if necessary, override its default value at run time.

THAT is correct, but you can not pass null to be looked up, even though the field is defined as nullable.

If AB occurs only in the first pipe-delimited field then what I posted is a complete solution. No condition is required in the stage variable, provided that the source column cannot contain null.

Not right.

You can not supply NULL as a lookup value. You can not compare NULL. Nothing equals NULL (at least you can not state legitimately that it does).

You will need to convert your NULLs into in-band nulls.

Let's start by checking what product you actually want to install. DataStage TX has not been known by that name for a number of years now. Are you installing WebSphere Transformation Extender, or are you installing DataStage?

Anything that might return NULL must be nullable. You can use any field you wish for comparison, but it must match data type and size (and, presumably, the occasional value).

Probably need a bit more clarity on what the pipe ("|") delimiters are doing. Assuming that the AB will occur only in the first delimited field, then create a stage variable, for example called svField2 svField2 = Field(Field(InLink.TheColumn,"|",1,1),",",2,1) If svFiel...