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
- 2483 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / 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 |
What are the differences between a connected lookup and unconnected lookup?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the different components of powercenter?
Design a mapping to load the cumulative sum of salaries of employees into target table?
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
Why we use ENABLE HIGH PRECISION in session properties?
Diff b/w ShortCut and reusabel Object ?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is joiner transformation?
waht is dataware house
In warehouses how many schemas are there?
Teradata 
