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
- 13480 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
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain about Informatica server process that how it works relates to mapping variables?
What is the maplet?
Is there any way to read the ms excel datas directly into informatica?
What are the different options available for update strategy?
Name the different lookup cache(s)?
Define mapping and session?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Can we get 1st record through Informatica(without sequence number).
Define sessions in informatica etl?
How do you load alternate records into different tables through mapping flow?
How to create or import flat file definition in to the warehouse designer?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is an Integration service in Informatica?
