DSXchange

Hi Raj Create a reject table/file Connect the reject table/file to the transformer enable the Reject record option of Constraints in Transformer stage The rejected records will be populated into the reject table, the records which are satisfying the condition will be loaded to the target table Hope ...

Hi All I had a Doubt in this, Kindly give me some thought process to resolve this I had a flat file where it is having 1 column i had to load the data into target table/file , the validation that i had to check is that i had to compare the immdiate previous record against the current Value. What are...

thanks for your valid response i had resolved my problem the Oconv conversion format is wrong i had tried with this code Oconv(Iconv(DSLink3.date,"D-DMY"),"D/YMD[4,2,2]") and it worked as i changed the date column datatype as timestamp if any chance can anybody throw me a light t...

Thanks ray for your response my intention is to store the date value into the database i had tried with changing the data type of date column from timestamp to date but still i am unable to populate the date value into table i had redirected the output to a flat file and it is having this data 1,22-...

Thanks for your response my code : Oconv(Iconv(DSLink3.date,"D-DMY"),"D-DMY[2,A3,4]") My source file structure no,"date" 1,"22-nov-04" my output is : 1,0022-11-20 04:00:00 I had specified my target table date column datatype as timestamp Thanks in advance RK

Hi all I am trying to load a column which is of date datatype i had encounter this error can any one share your views what might be the mistake Error message : ob1..Transformer_1: At row 1, link "DSLink4", while processing column "datett" Value treated as NULL Attempt to convert ...

Hi All

can any one share your ideas on this problem

Thanks in advance
RK

Hi All

I had encountered this error while working with a Sort Stage

Error :
Internal Error: sort specification error, function create_sort_spec returned [Invalid sort specification]

can anyone help me out what might be the problem

Thanks in advance
RK

Hi

the routine UtilityGetRunJobInfo will help u to find the start time and end time of a job

i think u had to use this routine and find a logic to get your required output

Thanks
RK

Hi ameyvaidya Thanks for your response The Routine works fine but it is not Full filling my requirement ex1: My String : ANSY, 3/4" SQ. DR., P/N 251-A626A, Routine Output : P/N 251 My Desired Output has to be : P/N 251-A626A Ex 2: My String : BE PON AY, P/N 436A90-A602, FOR Routine Output : P/N...

Hi All

I had executed the Code But it is not Working

I tried to Change it But didn't Succeeded

Can you Resend the Code

Thanks
RK

Hi All Thanks for your response But the problem is i am not sure the length of P/N . It may range from 0 to 20 digits . As the String Contains the Data as "P/N" as last characters of whole Description then the Length of "P/N" is 0. And this P/N can Lies anywhere in the Given Desc...

Hi All Thanks for your Great Response 1. I had to extract "P/N xxxxxxx" value that has been any where in the Given String 2. I had to Split the Given String into two Parts Like for Example Description = "BOLT, W/NUT, P/N P422 WISS,J.,&" From this I had to extract 2 Strings a)...

Can AnyBody Share your ideas how to extract part of a string from the given string

Hi All I had strucked up with a specefic Problem and need some guidence to resolve it. I had a String like "BOLT, W/NUT, P/N P422 AAAA,P.,&" and i had to extract a part of string like "P/N P422". The Problem is that the Part of the string that has to be extract can exist any ...