When i run workflow first session runs 4 times 5th time 2nd
session must run? How can u do?



When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?..

Answer / babu

Hi,

Wf-->s1-->Assignmenttask(var=var+1)--mod(var,5=0)-->s2
here var is variable it is declared in workflow level.
if every run of workflow var value increase 1,whenevr the
var reaches the value is 5 then only s2 will run.



Babu

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More Informatica Interview Questions

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,


In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  


explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,


What are the different threads in DTM process?

2 Answers  


Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,


Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,


In a concurrent batch if a session fails, can you start again from that session

1 Answers  


Why we use stored procedure transformation?

4 Answers  


I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,


can we use union transformation in joiner transformation?how?

1 Answers   Dabur, Tech Mahindra,


Explain scd type 3 through mapping.

0 Answers  


without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,


Categories