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
- 10904 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / nitin
Source->SQ->Sequence->Exp->Target
In Sequence Generator:
Give Start Value = 1
End value = 100
Check the Properties as CYCLE.
Give the following condition In Expression Transformation:\
O_SEQUENCE= NEXT_VAL
COUNT = IIF(O_SEQUENCE > 1 AND O_SEQUENCE <= 100, COUNT+10)
Make the default value of COUNT as 0
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Explain informatica architecture - version 8 / 9
difference between repository database and repository service?
How to use pmcmd utility command?
How many input parameters can exist in an unconnected lookup?
What is the function of look up transformation?
How can we use batches?
What is the maplet?
What are the mapping parameters and mapping variables?
What is decode in informatica?
What are the new features of Power Center 5.0?
What do you understand by term role-playing dimension?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Describe expression transformation?
Explain how many types of dimensions are available in informatica?
What is deployment group?
