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

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


diffrence between command task and control task

1 Answers   iNautix,


What are Rapid changing dimensions?

1 Answers  


how can we perform incremental aggregation?explain with example?

9 Answers   IBM, TCS,


What are the different versions of informatica?

0 Answers  


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,


Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  


can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,


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

0 Answers   IBM,


Please let me know how to make Data masking in informatica..

0 Answers  


Can you use one mapping to populate two tables in different schemas

2 Answers  


How do you convert single row from source into three rows into target?

0 Answers  


Categories