DSXchange

We just started using DS parallel jobs and I have a windows 2003 test box where I just started creating some sample jobs. When I created a parallel job with transformer I get an error and I have no clue where to start. Can anyone pls guide me? Output from transformer compilation follows: ##I IIS-DSE...

Hi, everyone, I got a problem about records output to unknown number files. For example, I wanna output the file: "abc","1","10" "def","4","40" "def","5","50" "ghi","9","90" "...

Due to VPN/Network issues while working on a job in designer, my connection is terminated. When i try to open the job again , It raises an error says "The job is accessing by another user". The job is accessible again only when the server is bounced. This option is very painful when many u...

I am developing a script which can export all ds jobs (.dsx) to automate backup process.

Please provide me command with parameters to execute in shell script and create .dsx file .

Thanks in advance.

Ray,

Thanks a lot. It worked.

Kumar

I am having issues with using multiple IF.THEN.ELSE conditions. Psl see below. I have 6 conditions to be tested in a single statement. I used a routing using a Begin..Case..END. Thsi worked good for few times. But all of a sudden the routine started giving errors in PROD server. When ever this happe...

Thanks. I guess it makes sense.

I need to capture non-matched recrods from the reference file. Its a Hashed file. I tried using the constraint RefLink.NOTFOUND, I see all blanks in the file. Any option other than swapping the Ref to Stream and Stream to Ref.

Kumar

Hi, We have lot of jobs running on production environment and of course we have lot of hashed files too. The amount of data that gets loaded in these files during job runs are extremenly high and it has become difficult data within hashed files. To basically validate data in hashed files, it will be...

I am creating a simple routine in server environment. This work perfectly when I test with Manager. When I start calling it in a sequencer, it acts weird. Initally I set the stage triggers based on the Return values 1 or 0. Then the routine does not trigger at all. It always used to fail. Then, I mo...

Yes - You can use them. You can create a shared container in a Designer and add the necessary functionality into it. Then you can call this shared contained (created in Server environment) in the parallel jobs.

Thank you Ray and Naveen. It worked.

What I need is Record1 in source should be duplicated to 10 records ( all Record 1) in Target. Hope it is clear on what I need. Thank you. Kumar [quote="shawn_ramsey"][quote="vskr72"]What I meant was is there way to copy 1 row from source and duplicate it into many rows in target...

What I meant was is there way to copy 1 row from source and duplicate it into many rows in target.

Kumar

[quote="kcbland"]What do you mean by "copy"?[/quote]

Hi,

How you copy one row to multiple rows in data stage?

Thanks.

Kumar