Interested to Buy Any Domain ? << Click Here >> for more details...
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
- 1 Answers
- 2394 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / abhishek
Need to use WF level variable which is a common factor between sessions . Pass value of 1st mapping variable to WF variable & then WF variable value to 2nd Mapping variable to control the behaviour.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How will the document be delivered to me?
How to Create a folder using pmrep command?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Define mapplet?
What are the types of schemas we have in data warehouse.
Write the prerequisite tasks to achieve the session partition?
How can informatica be used for an organization?
What the difference is between a database, a data warehouse and a data mart?
How can you generate reports in informatica?
Explain direct and indirect flat file loading (source file type) - informatica
What is session task and command task?
what is Active lock explain
what is the -ve test case in your project.
Explain the types of transformations?
