DSXchange

Well,

why don't u try with putting drop option for lookup failure ?
I believe it is set to continue now.

Sudarshan

Hey,

One simple way of achieving this is by using a lookup stage and putting the condition u have specified as the lookup condition and then dropping the lookup failures.


Sudarshan

Hey, Can u plss explain what use it will be to store three date fields in three different formats unless u r storing em as string ... because, whichever database u use will ultimately write to will store em in only one format. So, can u plss specify the datatypes u r abt to use, ur target and what e...

Hi,

Use the TimestampFromSecondsSince(seconds,timestamp) function. Note that here you can put number of seconds in negative value as well.

Sudarshan

Hi Balajisr,

If you go to EDIT->PROPERTIES and edit the job properties in the Defaults tab you can find the default date and time formats used for the job. There u can set your specific format to be used for the job.


Sudarshan

Hey !!! At last u r someone who is having the same difficulty as I had with DB2 Load stage in PX. 8) Now, do something, do the same job as a server job ... it will run smooth(if u have validation error ignore and run straight away after compiling). Now, for using the DB2 EE stage, did u do the follo...

Hi, In a transformer I am converting decimal coming in as varchar to decimal. When I use no conversion function it automatically converts correctly. For inputs which are not in decimal format it gives default zero. But when I use If IsValid("decimal",Trim(DSLink2.DECIMAL_1))=1 Then Trim(DS...

Hey ... WELCOME

n ... if u r new to DS as well, then I'll give u one sound piece of advice. Work on ur perseverance and patience !!!

U will require loads of em !! :D

Hi First check your source file whether you have the delimiters set correctly. Next this is to verify the source file Sequential File property and inside click the Format Tab and make sure that you have Null Field Value with some default value or empty string. Thanks Hey I did as per your suggestio...

Hi,

since you r converting date to timestamp I will assume u will give some default time ... say 00:00:00

U can use this : StringToTimestamp(DateToString(DateColumn):"00:00:00")

this should solve the problem.

Hi I am trying to develop a single job which will load data from one sequential file to another without any transformation, while the file names and the schema will be parametrized. I am using runtime column propagation and have already developed the job (I am not importing metadata ... I am only sp...