DSXchange

All, I am getting a TimeStamp in the format %yyyy-%mm-%dd %hh:%nn:%ss.2(2 microseconds) from my source and I have to insert the same into Db2 as 26,6(that is having 6 microseconds).Basically I thought of concatenating "0000" and inserting the incoming value. When I treat the incoming value...

All, I have a free text column(char 250) coming in and it can have lot of values separated by ",". Example a1,a2,a3,a4,a5,Z1,b1,b2,b3 a1,a2,a3,a4,a5,Z1,Z2,b1,b2,b3 a1,a5,Z4a3,a4,a5,Z1,b1,b2,b4 (Free text field can have the code in any place) and I have another look up table that have "...

Ray,

can you please let me know where it has to be and what has to be done to get it right.

Thanks
nsm

Yes Ray..I did add it via "Add Environment Variable" button only. All my individual jobs are fine. When I go into "Environment Variables list" its under "COMPILER". Then I changed the default config file name to what I wanted to use. all other parallel jobs whereever I ...

Hi All, I have $APT_CONFIG_FILE in my Env variables. I used it in some of my jobs and they all compiled okay. When i included it in the Sequence job I am getting the warning below. "Environment variable $APT_CONFIG_FILE defined in job parameters but not defined in project." Please let me k...

All, I am getting date and time 2 separate fields from DB2 and I have to concatenate date and time and insert as TimeStamp into UDB. The issue is when Time field has a value - "24:00:00" DataStage is not able to convert that to a valid timestamp(date:time) and returning "****..*"...

Ray, You mean the look-up or the count?? if the look-up doesn't work ,Please explain . another question I had was in Server Jobs if I have to populate the Dimension tables I maintain a hash and I write the records that I write in to the DB table to the hash so that I don't insert Duplicate rows. in ...

When I did the look-up using look up stage even though it ran in Parallel execution mode it worked fine in determining inserts or updates for the whole table. ( first I thought Look-up stage also works in parallel). then I thought always to DB or from DB its sequential.. So what I thought was after ...

Hello All, I have relational data model in DB2 now I have to transfer the data from 3 tables in DB2 to 4 Dimensions and 2 facts to my Warehose in UDB. Source tables have 6,2.5,4 million rows. No validations ..very few derivations..all are pretty much straight mappings. Once I do the bulk load first ...

Please let me know.

Thanks
nsm.

Hi you can have a message handler defined to filter the warning from log if any of the specified methods didn't work.

Hi you can have a message handler defined to filter the warning from log if any of the specified methods didn't work.

Hi All, I have a file coming in with 70,000 rows and has duplicates.For the unique combination of keys in the file I have to look up againest a DB2 table which has 70,000,000(70 million) rows. I am thinking best way to do this is create a temorary table in DB2 with keys from the file and then do the...

Thanks mctny..

I need to update the control table when I am at the last record..can we achieve this with in the same transformer stage?

My Target is an UDB table and I wanted to run a SQL using the stage variable from the transformer stage to update another control table.

Actually I need to update the control table only once(I can do at the last row) ..I am trying ways to avoid Aggregator Stage.

please help.