DSXchange

pradeep_nov18

ray.wurlod wrote:Funnel stage is really UNION ALL. If what you want is UNION use a Funnel stage followed by a Remove Duplicates stage (which implies a sort in there somewhere). ...

Ok Thanks ray

pradeep_nov18

Hi Experts,

How to perform Union operation for two tables.which stage shuold i use for this in datastage

Thanks in Advance.

pradeep_nov18

It means the format of your input data does not match your schema. One of your input records was much shorter than it should have been according to your schema. Hi toshea, Thanks for the reply, It was problem due to extra byte in some of the records. So can u explain how to handle like this situati...

pradeep_nov18

ya i have done that.
Thanks once again

pradeep_nov18

Thanks All :D !!!!!!!!!!!!!!!!!
I implemented for my scenario.Thanks for your kind reply.You guys are really masters in DS.

pradeep_nov18

OK, let's simplify things a bit. Declare a stage variable as type VarChar(8) and assign SAP_ATL_COST_SAVING_In.ZPRT_COSTSAVINGS_BEDAT to it (applying TrimLeadingTrailing if you must). Your express ... Hi Ray, Thanks For the Reply I tried with stagevar(i have test<Svname> and derv<TrimLeadingTrailin...

pradeep_nov18

You can't supply NULL to StringToDate() - you therefore need to re-arrange your logic and only do StringToDate() in the Else part of your conditional (If) expression. The error message relating to ... Thanks for reply Ray, But the changed the derivation to: If ((TrimLeadingTrailing(SAP_ATL_COST_SAV...

pradeep_nov18

Hi Datastage EXperts, I am converting the char(16) to Date(10) the derivation i am using is shown below: StringToDate(If (TrimLeadingTrailing(SAP_ATL_COST_SAVING_In.ZPRT_COSTSAVINGS_BEDAT)) = '00000000' Then SetNull() Else (TrimLeadingTrailing(SAP_ATL_COST_SAVING_In.ZPRT_COSTSAVINGS_BEDAT) [1,4] :&q...

pradeep_nov18

hi Syed, Thanks for the reply got some idea. my file name is in ETL server that that is local/data1/edw/temp folder, even i have parameterized this path accordling to my understanding.I have to prefix the date function with file name in that right,I am using parallel job so oconv and iconv is not th...

pradeep_nov18

i have developed parallel job for the replace load where one of the output Archeive filename must have prefix Date and time how to acheieve.So for every run Date and time must change and it must overwrite(For eg:<Path><date&timefilename.dat>) and frequency of load is daily.

pradeep_nov18

chulett wrote:Check that?

derivation which has posted not working.

pradeep_nov18

Hi ALL, I have requirement Input(SRC DATATYPE:CHAR(16)) Required(TGT DATATYPE:date(10) INPUT OUTPUT 00000000******** NULL 20080701******** 2008-07-01 I have give derviation in the column If SAP_ATL_COST_SAVING_copy_ln2.ZPRT_COSTSAVINGS_BEDAT = '00000000 ' Then Setnull() Else StringToDate(SAP_ATL_COS...

pradeep_nov18

keshav0307 wrote:A is the delimiter

thanks keshav number should be 1 right.

pradeep_nov18

shaonli wrote:You can achieve this by using Index function which finds starting character position of substring.
Target=Inputcol[1,Index[Inputcol,'A',1]].
Please try this

It should work

Thanks Shaolni

Thanks
Shaonli

pradeep_nov18

find the position of A and read 1 to that position. one option is to use Field(%string%,%delimiter%,%occurrence%,[%number%]) Hi Keshav Field(in.col,,1,) in Number can have any value and delimiter wat we have to give please can you Elaborate since there is no delimiter and number cannot be predicted

DSXchange

Search found 91 matches

Union

Char To Date Converstion

Re: Every Run date and time should change

Every Run date and time should change

Hi

Check that

Thanks

Thanks

Hi