DSXchange

Hi All,

Can we have lineage between the source file residing at unix box to the sequential file stage in job where the filepath and filename are parametrized.

The output of IsValid function is either 1 or 0.Change the derivation accordingly.

@Witty,

You are right..Delete is not a part of SCD.But an unwanted dimensional value need not be necessasary for an organization.For ex: a customer from a bank gets detached.Moreover,the bank doesnt need any info about him.
Now the delete operation helps.

Probably "string" alone represents a char or varchar field which is unbounded in its length.So the warning.

%(m,s)

indicates a numeric month of year field in which values can contain leading spaces or zeroes and be one or two characters wide.

Try StringToDate(Column name,"%(m,s)/%dd/%yyyy")

It might work..

It can be also enabled in job level.

This does not come under compilation category.

Enable APT_DISABLE_COMBINATION environmental variable to check which stage produces error...

Have you tried OCONV function..

Comparision done in transformer or lookup.

If in transformer,do you use stage variable?

How are you comparing the values

A Trim on the particular field will work..

Hi,

Have you checked the outcome of join operation which might have null values in the columns extracted.

Hi,

Enable the environmental variable OSH_PRINT_SCHEMA and compare the metadata.

Thanks for the support...

I tried with char and viewed the same...but in vain...