Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13315 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
Explain pmcmd command usage in informatica
What is a rank transform?
What is the cumulative sum and moving sum?
Is there any way to read the ms excel datas directly into informatica?
what is the -ve test case in your project.
Enterprise data warehouse your projects phase by phase explain?
What are multi-group transformations?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is informatica metadata and where is it stored?
What is data caches/ index caches?
Can anyone tell me the new features in Informatica 9 Version?
What is the commit type if you have a transaction control transformation in the mapping?
What is the use of an aggregator cache file?
Is stop and abort are same in informatica?
how to create user defined function (udf) in informatica
