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
- 13320 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
What does role playing dimension mean?
what is INFORMATICA TESTING process
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain about Informatica server process that how it works relates to mapping variables?
Under what condition selecting sorted input in aggregator may fail the session?
What is workflow? What are the components of the workflow manager?
What are the different ways to implement parallel processing in informatica?
How to extract the informatica rejected data?
How to do unit testing in informatica? How to load data in informatica ?
Enlist the various types of transformations.
What is the difference between stop and abort in informatica
How can you differentiate between powercenter and power map?
Why do you use Mapping Parameter and mapping variable?
What is update strategy transform?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
