DSXchange

and these columns are nullable columns.

Hi, I am loading a table with a data coming from csv file, It has null values in it, the column which has null is being used in stage variable and constraints, if not used in constraints, and stage variable then it never drops the records...if used it does so. i have used isnull to check if the colu...

Hi, I have tried putting start position and default value as 1 but it dint work out.It starts with 0... and as i am taking this column as a key column for join, the join stage is giving an error saying: " partitioner requires a key column" Note:i have put up hash partitioning with key as r...

Hi,


How to initialise RowNumberColumn to 1 instead of the default value 0.

ThankU,

Problem with job and sequence parameters,

As the sequence parameter had a an extra space in it which i overlooked.

its working fine now.

Thanku.

chulett wrote:Post the actual errors. ...

Problem with job and sequence parameters,

As the sequence parameter had a new an extra space in it which i overlooked.

its working fine no.

Thanku.

chulett wrote:Post the actual errors. ...

Hi, I have a sequence which gets aborted when run. it says due to unrecoverable errors, for this i compiled the jobs used in the sequence. the log of the job used in sequence says, "couldnot open the file " but when that job is run individually...they run fine. What could be the problem th...

I could see that this can be achieved by using transformer, but this goes fine with two columns ..

its going complex with the three column data...as shown

ray.wurlod wrote:Search the forum for "vertical pivot", which is what you are trying to do. There are several ways to effect this technique. ...

Hi,


I have some records in this manner,

A,AT1,GT1
A,AT1,GT2
A,AT2,GT1
A,AT2,GT2
A,AT3,GT1
A,AT3,GT2

OR

A,AT1,GT1
A,AT1,GT2
A,AT1,GT3
A,AT2,GT1
A,AT2,GT2
A,AT2,GT3




And i want the resultant recordS as

A,AT1,AT2,AT3,GT1,GT2 and

A,AT1,AT2,GT1,GT2,GT3


Please suggest.

Ok
I have done this.

thanku.

Zhang Bo wrote:you should change both the input and output nullable to YES,and this warning must be removed

Hi, Actually i am moving the data from a table to a text file .so this leads to make it work. Thankuu.. I don't think that's the right way to do it. Because you are passing a SPACE character (' ') when it is null. This would need you to put a logic which converts the SPACE into a null before it inse...

Hi, It worked fine when gave the query as: SELECT NVL(TO_CHAR(TRUNC(LAST_UPDATE_DATE),'YYYYMMDD'),' ') LAST_UPDATE_DATE FROM <<TABLE>> Can you give us the design of the job, It would make the task of fixing up this warning easier. But, My guess is that you are using this column --> 'LAST_UPDATE_DATE...

I have put up that as well

vikasjawa wrote:Hi
Just try setting the nullable property of the cloumn to "Yes".Hope so this would work.

When theres null value in one of the column in a table. when that column value is used any transformer or any other stage.

the row which has null value in a column is being dropped.

please help

i am not using. it any where.

i ll change the query.

balajisr wrote:Are you using the field 'LAST_UPDATE_DATE' in the transformer?

If so, post the derivation in which you had used the above field.