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 / 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
wat are deployement groups in informatica, how it will be used for developers
What are the settings that you use to configure the joiner transformation?
What's the layout of parameter file (what does a parameter file contain?)?
can anyone suggest best free Talend data integration training online
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain your project of banking domian.
How can you validate all mappings in the repository simultaneously?
What are batches?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is a connected transformation?
Can we create a Integration service without a Repository service and vice versa?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
As union transformation gives UNION ALL output, how you will get the UNION output?
What all join we can perform in LOOKUP transformation?