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
Search found 370 matches
- Wed Jan 23, 2013 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: duplicate record at lookup
- Replies: 3
- Views: 6072
- Thu Jan 17, 2013 3:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: duplicate record at lookup
- Replies: 3
- Views: 6072
duplicate record at lookup
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...
- Tue Jan 15, 2013 4:54 pm
- Forum: General
- Topic: can we set current date in project level parameter?
- Replies: 1
- Views: 2134
can we set current date in project level parameter?
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?
and use it in email notification?
OR
how to set current date in email notification subject?
- Thu Jan 10, 2013 11:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can I pass through columns in Aggregator?
- Replies: 10
- Views: 9356
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...
- Thu Jan 10, 2013 11:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can I pass through columns in Aggregator?
- Replies: 10
- Views: 9356
- Thu Jan 10, 2013 10:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can I pass through columns in Aggregator?
- Replies: 10
- Views: 9356
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...
- Thu Jan 10, 2013 9:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can I pass through columns in Aggregator?
- Replies: 10
- Views: 9356
- Wed Jan 09, 2013 4:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How can I pass through columns in Aggregator?
- Replies: 10
- Views: 9356
How can I pass through columns in Aggregator?
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...
- Wed Jan 09, 2013 2:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if then elseif
- Replies: 5
- Views: 4580
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()
- Wed Jan 09, 2013 2:21 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: if then elseif
- Replies: 5
- Views: 4580
if then elseif
how can i code--if then elseif
in a stage variable?
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
- Tue Jan 08, 2013 11:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String conversion
- Replies: 6
- Views: 3955
- Tue Jan 08, 2013 11:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String conversion
- Replies: 6
- Views: 3955
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...
- Tue Jan 08, 2013 9:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String conversion
- Replies: 6
- Views: 3955
String conversion
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...
- Tue Jan 08, 2013 1:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple lookup condition
- Replies: 2
- Views: 2408
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...
- Tue Jan 08, 2013 12:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: multiple lookup condition
- Replies: 2
- Views: 2408
multiple lookup condition
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
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