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
- 13280 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
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
how many types of dimensions are available in informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
Explain lookup transformation is active in informatica
Explain the different dimensions.
How to create the source and target database connections in server manager?
What is Index Caches size?
What is data transformation manager process?
What is a standalone command task?
What is decode in static cache?
How would you copy the content of one repository to another repository?
How will the document be delivered to me?
Informatica Checkpoints
How can we improve session performance in aggregator transformation?
Explain about Informatica server process that how it works relates to mapping variables?
