DSXchange

Century issued is solved. I have used %1980yy for year part. But unable to find out why those 37 records are getting rejected with the below error. ORA-01841: (full) year must be between -4713 and +9999, and not be 0 This field is coming as a string(6) with the format 'mmddyy'and converted to timest...

Thanks Craig for your prompt reply. I have seen a log file and all 37 rows rejected are from the same field that is timestamp datatype. Even though the job is aborted ,I am able get to all the other records in the target table in the database. Loaded records are displaying 19th century dates. How ca...

I get the below warnings and my job is aborted. Help needed to get rid of them.Source and target is oracle EE stage between them is a transformer where i am handling stringtotimestamp, decimaltodecimal and null string fields to null timestamp conversion and some more.My source has 710867 records. Lo...

Senthil,
In my case join won the race. Lookup consumed more time then join.
As per the volume of data mentioned above in my topic, join proved to be efficient.

Thanks Ray.

I have tested this case with join(left outer) and with lookup stage (condition not met=continue,lookup failure=continue) . In both of these cases the resulting records is not equal. Suppose if have 1000 records in driving table and 2000 records in the right table. Join with left outer condition retu...

Thanks Guys.

Thanks Senthil. But how abt sparse lookup?
Is it possible to make reference table as a source and vice versa and do a lookup.

I have 26 million rows in oracle refrence table and around 2 lakh rows in a source (in my case ouput from a join). I need to implement a left outer join with driving table as a source(in my case ouput from a join). Is it better to go for a join stage with left outer condition or a lookup stage? If l...

Ray, I mean to say a FUNNEL (union)

Input datatype is number(15,0) from Oracle. I have set this as integer 15,0 in every stage . I receive negative numbers in the output. I have two similar dataflows coming into the UNION( but i have written only a single flow upthere in the topic).

Any help to fix this thing is appreciated. Oracle---> join--->sort---->union----->Sequential file. columnname(Number(15,0)) target(Integer(15.0)) 25558 -2345635343 36667 -34567 12345 -45636 I have set the datatype as integer 15,0 in every stage in the flow and i am receiving the above negative value...

Ray I would like to do that but need some time.

Thanks Ray but i could only see the first line of your content.

Sorry for not being precise.
This code will get the values or records of midnight of last day of last month.

For example:If sysdate is 12-Dec-2011 then the result is 30-Nov-2011 12:00am or 1-Dec-2011 00:00 am.