Interested to Buy Any Domain ? << Click Here >> for more details...
i have 1000 records in my dource table, the same i have in
target ,but a new column added in target as "batchno", and
this column adds no 10 for 1st 100 records and 20 for next
100 records and 30 next 100 records and vice versa. how to
acheive this?
- 6 Answers
- 12099 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / santosh
Please follow the below step.
1.Create sequence geneteor which will start with 1.
2.Connect the nextval port to expression t/p.
3.connect port from sq transformation to expression t/p.
4.Create below port in the expression transformation.
a. NEXTVAL_OUT(Variable port)= NEXTVAL-1
b.rec_con(Variable port)= IIF(NEXTVAL_OUT % 100 = 0, REC_CON+10,REC_CON)
c. REC_CON_OUT(Out put port)= rec_con
5. If you have primary key on the target table then use update startegy t/r to update the targer.
6. If you don't have primary key on the target table then use update voerride in the properties tab of the target.
7. U can use the below query to update the target by update override.
UPDATE EMP_UPDATE SET REC_COUNT = :TU.REC_COUNT WHERE EMPID = :TU.EMPID
Please correct me if anything wrong.
Thanks and Regards
Santosh Kumar Sarangi
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to extract sap data using informatica? What is abap? What are idocs?
What is complex mapping?
How many types of sessions are there in informatica.please explain them?
Write the program through which the records can be updated?
What is lookup change?
What is option by which we can run all the sessions in a batch simultaneously?
Where are the source flat files kept before running the session?
How to partition the Session?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
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
How to differentiate between the active and passive transformations?
Can we override a native sql query within informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is a stored procedure transformation?
