Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

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

9899


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

2199


what are 3 tech challenges/ common issues you face?

2395


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2578


How to differentiate between the active and passive transformations?

1229


Explain pushdown optimization $pushdownconfig parameter - informatica

1195


Define pmcmd command?

1105


what is the complex transformation you used in informatica

2623


What is the benefit of partitioning a session?

1235


What are the tasks that can be performed using sq?

1141


How do you handle two sessions in Informatica

1219


What is an expression transformation?

1078


What you know about transaction control transformation?

1057


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)

1678


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.

1223