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
- 13335 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
Enlist the advantages of informatica.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
How do you handle two sessions in Informatica
Could you explain what is enterprise data warehouse?
What is a connected transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
r u done any partitions in ur project?
What you know about transaction control transformation?
What is a rank transform?
Explain what transformation and how many are there in informatica?
What are the designer tools for creating transformations?
State the differences between sql override and lookup override?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How many ways are there to create ports?
