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...

My questions is i create a two sessions for one mapping.but
my requirement is if all number of source records are same
as in target then execute first session or some rows are
rejected due to t/r logic so session two was execute
please clarify

Answer Posted / harleen

This is the case that we use for audit balancing in our project.

At the starting of the session have the source count and checksum of a field and write it into a file.After the load is done in target count the number of rows in the target and write the values in a file.After the target load session is over,use command task and have a script that compares the two scripts.If the count matches scripts succeeds else fails.In assignment link give condition that session.status =SUCCEEDED then first workflow and session.status-FAILED hen second workflow

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What's the layout of parameter file (what does a parameter file contain?)?

2387


Explain how to import oracle sequence into informatica?

1020


What does “tail –f” command do and what is its use as an Informatica admin.

1108


Separate from a database, an information bazaar, and an information stockroom?

1089


tell me the rules and responsblites in our project(my project is development)

1933


Whats there in global repository

1696


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10687


How many numbers of sessions can one group in batches?

1064


What is meant by active and passive transformation?

1126


Can we create two repositories on same database instance in oracle?

1097


What is pmcmd command?

1125


How do you manage the Parameter files while migrating your data from one environment to another environment?

1029


What are the tuning techniques you applied during your last project

2027


What are the different components of powercenter?

1055


Where is metadata stored?

1117