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?
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 differs when we choose the sorted input for aggregator transformation?
how i will stop my workflow after 10 errors
can a port in expression transf be given the name DISTINCT
what is lookup chache?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
How to Join Tables my Source is having 15 table target is one?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
In joiner, how to load Master table in Target?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
can we load the data with out a primary key of a table? what is target plan?
in which situations do u go for starflake schema ?
How to join three sources using joiner?