I have one source table and three target tables.
When the session runs for the first time involving the
mapping,i want that the loading should take place in 1st
Target table only.
The 2nd time the same session runs the loading should take
place in 2nd Target only only
and similarly when the session runs for the 3rd time loading
should take place in Third only.
And again when the session runs for the 4th time loading
should take place in 1st Target table.
- 4 Answers
- 12455 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / vineet katyal
take mapping variable $$count-to count the number of session runs(initial value as 1 and default value as 1)
from source take the input to expression transformation and add two variable ports
V_flag=DECODE(MOD($$COUNT,3,1'FIRST',2,'SECOND',0'THIRD')
V_count=SET VARIABLE($$COUNT,$$COUNT+1)
now router transformation
three user defined groups
v_flag=first
v_flag=second
v_flag=third
now add three groups to three targets.
after every successful session run the mapping variable value gets updated by 1 in the repository.
first time the variable value will be 1 as SET VARIABLE WILL BE PROCESSED AFTER FLAG VARIABLE PORT
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is parallel processing in informatica?
What is primary and backup node?
How many ways a relational source definition can be updated and what are they?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Partition, what happens if the specified key range is shorter and longer
How many ways are there to do 'remove duplicate records in informatica'?
What is meant by LDAP users?
What is joiner change?
pmscmd startworkflow -sv
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How to join three sources using joiner?
