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?
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
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is mapping debugger?
Where are the source flat files kept before running the session?
Can you generate sequence numbers without using the sequence generator transformation?
What are the databases that informatica can connect to windows?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to generate sequence numbers without using the sequence generator transformation?
Mention few power centre client applications with their basic purpose?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What can we do to improve the performance of informatica aggregator transformation?
What are the differences between oltp and olap?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Explain the different kinds of facts.
How many ways a relational source definition can be updated and what are they?
Explain how many types of dimensions are available in informatica?