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
What is meant by lookup transformation?
Do you find any difficulty while working with flat files as source and target?
Write the prerequisite tasks to achieve the session partition?
Can anyone tell me the new features in Informatica 9 Version?
What are the types of lookup transformation?
What do you understand by a term domain?
is it possible to index the data in cache of lkp transformation ?
What is meant by pre and post session shell command?
How many dimensions are there in informatica?
Separate from an archive server and a powerhouse?
how to load rows into fact table in data warehouse
Which transformation is needed while using the Cobol sources as source definitions?
Which development components of informatica have the highest usage?
What is the reusable transformation?
According to his methodology what all you need before you build a datawarehouse