DSXchange

1st question: How to write Store procedure in DB2
Ans: Ask your DBA.. I dont have idea
2nd question: how to call in DS?
Question: Do you want output from STP into DS? or Just execute STP ...

Thanks,
Anupam

Use ExecSH before-subroutine to rename the file... even you can pass parameter for file name


Thanks,
Anupam
sb_akarmarkar@smart-bridge.co.in

loveojha2 wrote: But with such a solution, you should be pretty sure of whether the target links are fully processed or not?

It will wait for link .....


Thanks,
Anupam
sb_akarmarkar@smart-bridge.co.in

Suppose Source Link name is SrcLink Target Link name is TgtLink Transformer name between is TransformerX Link one more transformer name TransformerY to TransformerX Put constraints @OUTROWNUM = 1 Give following in TransformerY for link count DSGetLinkInfo(DSJ.ME, "TransformerX", "SrcL...

I think you need following information
1) How many rows selected from source.
2) How many rows insert/updated to target.
3) How many rows reject.

I suggest better to go with GetLinkCount()
@INROWNUM and @OUTROWNUM will not get proper information

Thanks,
Anupam
sb_akarmarkar@smart-bridge.co.in

Use routine GetLinkCount(JobName, StageName, LinkName) that will give you count ...
You can create a multiple instance job where you can pass parameter to that job and get count for each job...

Thanks,
Anupam

What you desire with routine .... it does not look logical...
As per you...
1) How you trying to send input to routine?
2) How you will get max value from routine ?

... I think you must go head with aggregator..

Thanks,
Anupam

Is the generated query showing to_timestamp('2005-10-19 11:21:38.0','YYYY-MM-DD HH:MI:SS:FF') ? if not you can go head with user defined or else default format is to_timestamp('19-oct-05 11:21:38.0','DD-MON-YY HH:MI:SS:FF') so in transformer get date to the above default format and insert. Date will...

Job type you have mention is parallel and posted query in server forum...


Thanks,
Anupam

Use routine UtilityHashLookup which returns file or table not found if there is no file ..... by this routine we can validate the file present or not...

Thanks,
Anupam

Thanks all for there suggestion....


kumar ...

If we reading from source stage just put filtter in transformer to false
so we can get reading time ...
Suppose reading time is 3 min
Writing from text file to taget 7 min
whole ETL time is 30 min...
like that we calculate...

Thanks,
Anupam

Thanks all for your reply.... :D

Thanks,
Anupam

You can use IPC Stage to specify that connected active stage should run as seperate processes. You can also use IPC stage between two passive stages to speed up transfer of data between them. Hi balajisr, If suppose one of my process in ETL is taking 3 min to execute and another 20 min, so is it fe...

Hi all,

Is there any performance benifit of using IPC stage ?
In which cases we can use IPC stage


Thanks,
Anupam

Hi all,

Can any one tell me what exactly allow mutiple instance will do ?
will it copy code and run apart from other ?
If multiple instance job start at same time what will happen will it abort one or ...?


Thanks,
Anupam