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
- 10898 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / rajkumar
it's just like a simple pass.But we have to use an
expresion in between source and target we have to continue
the loop of variable port has to continue for every 100
records.
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is the difference between stop and abort in informatica
What are the new features of Power Center 5.0?
How are indexes created after completing the load process?
How might one distinguish in the case of mapping is right or not without associating session?
Define update strategy?
How you know when to use a static cache and dynamic cache in lookup transformation?
How is union transformation utilized?
Explain in detail about scd type 1 through mapping.
How identifying bottlenecks in various components of informatica and resolving them?
What is session task and command task?
Explain the types of transformations?
What is a predefined event?
What are the types of lookup transformation?
What is target designer and target load order?
Which development components of informatica have the highest usage?
