DSXchange

Hi All, I have to populate to one of my target table column as per the below logic: -populate "xxx" -if value is not there for "xxx" then Populate "yyy" -if value is not there for both "xxx" and "yyy" then populate "zzz" -if value is not th...

hi us1aslam1us when i tried to remove NullToEmpty function ,the rows are getting rejected. from table it is extractiong 20000 rows ,but from transformer only 500 records are passing to next stage. i am getting error like: APT_CombinedOperatorController(0),0: Field 'AAA' from input dataset '0' is NUL...

Hi ccatania,

Thanks for ur response and will be happy if you could give me the exact derivation using my columns like xxx,yyy,zzz(previously mentioned)

so that i can get solution.

for ex: Isnull(xxx)...like that


thanks
help would be appreciated

Thanks Guru2B,

I implemented the logic sameway but i am getting onle column1 values and remaining are nulls.but not populating col2 vals or column 3 vals.

note:

i used NullToEmpty() function for thease columns in the first transformer.

is it giving the problem?

should i remove it?

tx

Hi All, I am facing some issue to implement some simple logic in my job. Could any one please help me on this. i have source table with columns like" xxx","yyy","zzz" and i have to populate to one of my target table column as per the below logic: -populate "xxx&quo...

Hi All,

Thanks a lot for your advises and my job is now running fine.

Thanks to every one.

and the column 'xxx' is Varchar-50

the column 'yyy' is Integer-10

do i need look into this way?

yes balaji,

there is null values in input column xxx.

but i used derivation in Transformer_145,to handle nulls, like:

If IsNull(DSLink147.xxx) Or Trim(DSLink147.xxx) = "" Then "" Else (DSLink147.yyy)

thanks

Yes ray/arndw,

DSLink147.xxx defined as Nullable. for that column the option:

'Nullable' is set to 'yes..

Hi, Following are the error messages i am getting,when i run my job: 1)Transformer_145,0: Failure during execution of operator logic. 2)Transformer_145,0: Fatal Error: Null value on the accessor interfacing to field "xxx". 3)node_node1: Player 27 terminated unexpectedly. This job basically...

hi dsguru2B

Thanks for the reply and i tried same as mentioned in the post.

but i am still getting the same error.

tx

hi all, could any one please through some light to solve my problem: error is: Fatal Error: Null value on the accessor interfacing to field "XXX". i checked source and target(xxx)fields length and nullable-yes options. but still i am getting error. please help me on this. tx in advance.

Hi All, I am just curious to know that, 1)What will be happens, if we run the jobs on MPP systems,which are created on SMP systems. 2)My dev box is on SMP System and if I move my production server to MPP Systems,what will be happens?means does it affects our individual job behavior or decreasing per...

Hi All,

I have a Input file has following columns:

Name, age, sex,pan,city,zone (there are 4 zones)

And I want out put file like for each zone(for 4 zones) I require sex and average age.


how should i approach this..

can any one help on this

tx in advance

Can someone help me on "how to get the column value in target file name"? For ex: In my source table I have a column "Status" The values of that column may vary as ("RJ" or "RL" or "FD") If staus="RJ" ........................I need to creat...