DSXchange

Hi,

I am new to routines..I need a help about writing a routine..which will create a procedure and will execute it.

Thanks
Sagar

we have message handler available in sever also.... but documents speaks only about parallel....anybody have idea?

if we supress this warning for this job will it help?

ETL job receives 2 files (or 1 file) and inserts into PeopleSoft Staging table. Whenever we receive 1 file the ETL job finishes but with warning message saying that another file was not found. MetlifeBillSeq..JobControl (DSWaitForFile): Timed out after 00:00:05 while checking file '/BOSS/PXWork_12/s...

Hi Sainath,

How it will work whhen the key is changed?

Hi I have a condition where.... from input i am getting two columns as below :- ID NAME 1 XX 1 YY 1 XY 2 SS 2 DD 2 PP I WANT OUT PUT AS -----------> ID NAME 1 XX#YY#XY 2 SS#DD#PP HOW CAN I ACHIEVE THIS....??? I AM USING DS SERVER EDITION. *Note: Title edited to be more descriptive - Content Editor*

Thanks this is what i wanted.

as in the mapping we will be taking columns from After Dataset only..so will we get value for 2 with a delete code?
what will be the value of other fields...in this case...
1 , 2 , 3 these are just change keys which i mensioned there will be other columns too

Hi I have a before dataset with (1,2,3) records in it. and After Dataset with (1,3) records in it.( 1 , 2, 3 --these are change key values) Change mode - is Explicit key , all values. In case of which record out of 1 , 2,3 the delete code will be generated....? and if the target is the a oracle tabl...

Hi I am loading data into the Oracle table.But the data volume is relatively huge so the job is getting aborted....as per DBA we are running at the highest table space....is there any performance tuning that we can do to avoid this problem

Hi Ray,

Thanks for the valuable guidance.....also one more thing i would like to know .....do we need to write C++ code in per-record tab only.......
also how to test and debug the rquired code is woking coreect or not...?

Hahahaha...you smashing like anything.....i know you are genius.....but when i saw such a thing in my designer i got little bit confused.....So i raised my eye brow.....

Can you tell me how can we create such a custom stages.....

Well how can you bve so confident?

if you go to the utility section of pallet....you will find that stage....

any idea? how it works?

recently i have seen a job, in which a flat file will be given a input to a dynamic file write stage.......flat file willl be holding xml data......

can anybody tell me how dynamic file write stage works? and why it is used..>?
i didnt find any content about it anywhere

I have again checked in the unix the file isgood only..no problem with the data...even the columns are properly defined with data types.....
what could be the error....?
As i tried to change the data also...Gave some different data but it is not workking.....again same error only.....