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
- 11834 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / kamleshmishra291
Create a mapping variable $$INCR=1
Take Expression Transformation after SQ
In Expression Transformation create a variable port:
v_count_session=IIF($$INCR=4,setVariable($$INCR,1),setVarialbe($$INCR,$$INCR+1))
After Exp take a ROUTER Transformation and create three groups with conditions :
GROUP1
$$INCR=1
GROUP2
$$INCR=2
GROUP3
$$INCR=3
Finally connect groups to group1--tgt1, group2--tgt2, group3=tgt3
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
can we override a native sql query within informatica? Where do we do it? How do we do it?
Parameter and variable differences
How do you convert single row from source into three rows into target?
Mention few power centre client applications with their basic purpose?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to elaborate tracing level?
During the running session, output files are created by informatica server. Enlist few of them.
How to create a non-reusable instance of reusable transformations?
Define mapplet?
Design time, run time. If you don't create parameter what will happen
What is an aggregator transformation?
Explain what is informatica metadata and where is it stored?
What is a filter transformation and why it is an active one?
How can repository reports be accessed without sql or other transformations?
Write the advantages of partitioning a session?
