DSXchange

Hi, I have a transformer where i basically join 2 different tables from different source. I need to somehow capture the Rejected records and the Filtered records at the same time without additional constraint in the transformer. An example will make it clear I Have Table A from source1 and Table B f...

Hi All, I want to capture job log information into text file. i have given this query in job control (c:\Ascential\DataStage\Engine\bin\dsjob -logdetail DMCProj1 CopyOfCon_Cons 1 20 > E:\DMC_Data\DSProjects\DMC_DEV\log\Con_Cons.txt). In this case log will dsplay based on event id but i want total lo...

Hi All,

My target is DB2 one column datatype is timestamp(26) how can i pass Data Stage timestamp value into that field.

DB2 Timestamp format is different and Data Stage farmat is different.


Please give me a suggestion on above matter.

Thanks

The issue is resolved. The problem was with the Metadata... Metadata was imported from a CFD and it had levels. On removing the levels it worked fine. Thanks Hi, Are you sure about, dummy column is present in all four input sequential files and check the nullability of Dummy Col in all four input fi...

hi, I'm using a Join stage with 4 sequential files as inputs. Using Inner Join on a dummy key(integer(1)). However, the job fails at runtime throwing the following error: Non-aggregate component in select:dummy.col1 Col1 is an integer(1) nullable field from one of the files. Kindly help... Thanks.

Can I take Block variables in the match variables ??

e.g -- In the Block Variables -- ZIPCODE
In the Match variables -- NAME, ADDRESS and ZIPCODE

Is this possible ?? will it give me actual result ??

Hi
I am trying to do a probabilistic match(many to one) in the match stage.
I want to do entire record match without specifying any blocks. Can anyone help me out how to do this. If anyone has any example please send it to me.

Thanks

Hi,

My source coming from access database in that table one field contain multiple lines data that field data type is memo in access same i transformed into target(DB2) but in target stored before and after data stored some junk values how can i handle in data stage and which fuction will usefull.