Dynamic loading

[naveenshindhe]

Hi,
Please any one let me know
1. What is dynamic loading.
2. Table A contains
Col1 Col2
-------------
1
1
1
2
3
2
3
1
in Col2 I have to put the values like this..
in first row 1 has occured first time so in Col2 value should be 1 and in the second row again 1 occured second time so in Col2 value should be 2.. like this for every occurance of the digits there should be an increment in
Col2 ..the output should be as follows..

Col1 Col2
-------------
1 1
1 2
1 3
2 1
3 1
2 2
3 2
1 4

3. I have 3 sessions in a batch.
S1, S2, S3.
If S1 is success then I have to run S2.
If S2 fails then I have to run S3.

Please tell me how to do this.

4. First I have to run S2, then S1 then S3.

Please tell me how to do this.
Thanks
Naveen

 

[srpvc]

for your second one
You can sort based on col1 and use variable port which will contain incresed value by 1 if previous record and currect record is same. if previous record and currect record are different then reset this varianle to 1.
even you need to have one more variable to track previous col1 value.

For 3rd and 4th you can use connect them in workflow and specify conditions in links.

Hope This will help you.