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



My questions is i create a two sessions for one mapping.but my requirement is if all number of sou..

Answer / 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

More Informatica Interview Questions

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,


WHat all joins are there in Source Qualifier?

1 Answers  


How can you define a transformation? What are different types of transformations in Informatica?

10 Answers  


enterprise datawarehouse your project phase by phase explain?

1 Answers   Cap Gemini,


Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,


Explain what transformation and how many are there in informatica?

0 Answers  


how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,


what is worklet and what use of worklet and in which situation we can use it?

4 Answers   Patni, TCS,


How to do the error handling of if ur source is flatfiles?

0 Answers  


Sequence generator, when you move from develoment to production how will you reset

0 Answers  


What is data caches/ index caches?

0 Answers  


How is Data Models Used in Practice?

1 Answers  


Categories