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
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
what are 3 tech challenges/ common issues you face?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to differentiate between the active and passive transformations?
Explain pushdown optimization $pushdownconfig parameter - informatica
Define pmcmd command?
what is the complex transformation you used in informatica
What is the benefit of partitioning a session?
What are the tasks that can be performed using sq?
How do you handle two sessions in Informatica
What is an expression transformation?
What you know about transaction control transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.