DSXchange

qutesanju

thanks I used sort stage with key change column and redirecting rows with keychange as 0 to file.

this way i was able to see duplicate records in separate file

qutesanju

I do have a lookup as DB2 table | | | | ----input data stream-->Lookup--target stream | | reject file Also in lookup i specified conditions as input.key1=db2table.key1 based on condition Flag = OUT input.key2=db2table.key2 based on condition Flag = IN in lookup constraints I specified action as cond...

qutesanju

can we set current date in project level parameter?
and use it in email notification?

OR
how to set current date in email notification subject?

qutesanju

Thanks all for your inputs ,so the solution is if you want to keep varchar data type in your group by flow use min amd max functions and use preserve type=TRUE only for varchar data type and preserve type=FALSE only for numeric data type this way all columns get populated to taget Thanks for best DS...

qutesanju

Got it

Stage --> properties --> Agrregations ---> aggregation type calculation --> click on column for calculation --> see in available properties to add .

qutesanju

perfect chulett ,thanks for solution, but i m unable to find where should i set and enable the 'Preserve type' ? i can see only decimal property for SUM column? when i used max(name) or max of any varchar data type ,it be default populated dfloat or double in column filed i manuaaly set its datatype...

qutesanju

I used max function for rest of other columns and data populated as null

will max or min function work for varchar type of data?

qutesanju

Let us say from input stream there are 10 columns coming and I'm grouping based only on 2 columns and assume plus one column as SUM, how to map remaining 7 columns from input to output? Or through the aggregator? As aggregator will not allow remaining columns directly mapped from input to output bec...

qutesanju

do you mean like this?

Code: Select all


if       lnk_lkp_filter_table_xfmr.C_ACH_DIR = 'IN' then  lnk_lkp_filter_table_xfmr.N_AC2 

else  lnk_lkp_filter_table_xfmr.C_ACH_DIR = 'OUT' then lnk_lkp_filter_table_xfmr.N_AC1 

else setNULL()

qutesanju

how can i code--if then elseif
in a stage variable?

Code: Select all

if       lnk_xfmr.DIR = 'IN' then  lnk_xfmr.AC1 
else if  lnk_xfmr.DIR = 'OUT'then nk_xfmr.AC2

qutesanju

i put output in sequencial fine also,but there also its getting displayed as Square square square square

qutesanju

i never said some junk character is part of ETL,i know its coming from clients data i m investigating why and we have no authority to change it but we can convert it atleast using some string functions in input i can see its coming as correct.however in ooutput its displaying as square square square...

qutesanju

i have inut column coming from db2 as char40 and i mapped to oracle target table as varchar35 however in oracle it gets displayed as ascii character or some junk charater any idea which string conversion function to use? my understanding is that it should display at least 35 charaters,but surprising...

qutesanju

lookups are on same table and i need to get 4 columns from first lookup and this will get passed to second lookup as input flow right now i implemented two separate lokup ,but i m not sure why its not retriving the lookup filed(4 columns) i mapped 4 columns into one flow should i leave them blannk w...

qutesanju

Lokup condition
In one lookup itself can i put both condition?

(ToLkp.Flag ='INT' And ISNULL (ToLkp.Table_id))
(ToLkp.Flag ='EXT' And ISNULL (ToLkp.Table_id))
so i dont need to use two separate lookups for one for each condition

DSXchange

Search found 370 matches

duplicate record at lookup

can we set current date in project level parameter?

How can I pass through columns in Aggregator?

if then elseif

String conversion

multiple lookup condition