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
- 13292 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
tell me about your project functionality
How can you define user defied event?
What does reusable transformation mean?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Difference between Target-based loading and constraint-based loading?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Is it possible to use a client with different version than that of its Informatica server?
What is depict expression change?
wat are deployement groups in informatica, how it will be used for developers
Explain the scenario which compels informatica server to reject files?
Repository user profiles
can any one give some examples for pre sql and post sql(Except dropping and creating index).
