Interested to Buy Any Domain ? << Click Here >> for more details...
i have a wf like wf-->s1-->s2-->s3-->s4
first start s1 later s2
later s3 here my session s3 have to run 3 times later start s4?
- 3 Answers
- 7200 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ankit
I believe this can be achieved through Assignment task set a
variable var = var+1 & check mod(Var/3)=0 .
Other not so good approach as you are increasing more code.
create S3 in another workflow & call it from PMCMD command.
Please let me know if some one has a better approach .
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is enterprise data warehousing?
what is the hint? how to use it to reduce the query processing in program?
What are ETL Tools?
What do you understand by term role-playing dimension?
What is informatica powercenter repository?
How does the aggregator transformation handle null values?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the difference between source qualifier transformations source filter to filter transformation?
How do you load alternate records into different tables through mapping flow?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
How to handle decimal places while importing a flatfile into informatica?
Different circumstance which drives informatica server to expel records?
Explain direct and indirect flat file loading (source file type) - informatica
