DSXchange

Check whether you are violating any unique key constraint at your target table.

Are both versions are installed in same unix server. If yes, check the values of the parameters that got populated through Environment variables by seeing the director log.

RowDelim will be a Stage variable which will be having some character as value.

Did you see the syntax for Field function in help.

Look for parallel version of Ereplace function which is posted in this forum.

Yes Criag. It is in scratch disk area. Thanks.

Hi, In one of my jobs having Oracle enterprise stage, where I am using Write Method='Load', I am getting the below error. The system(sqlldr CONTROL=ora.6316232.131678.2.ctl LOG=ora.6316232.131678.2.log BAD=ora.6316232.131678.2.log.bad SILENT=header PARFILE=ora.6316232.131678.2.par) failed; see the l...

Do a search in this forum. This has been answered earlier.

You can call the JobStatistics routine through Job sequence instead through Before/After option. Keep your job in a Job sequence and make sure that the JobActivity stage name reflects your exact job Name. When your job is executed successfully execute the routine using Routine stage. Here you can ea...

Use remove duplicates stage with GRP and AGE as Key fields.

Use Mod() function. Mod(INROWNUM,3)
If the value is 0 it will go to one link, if it is 1 then it will go to another link and so on.

Can you check the output for the command you executed from director log .

( (@INROWNUM - 1) * @NUMPARTITIONS + @PARTITIONNUM + 1)
Use the above derivation to get the record count

In the administrator command prompt, type ds.tools and execute. It will guide you from there.

Add one dummy column(Value=1) while writing into datasets and group by based on that dummy coulmn to get the count.