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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / dharma


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

can we load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

Can you copy the session to a different folder or repository?

1 Answers  

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

What is the difference between a repository server and a powerhouse?

0 Answers  

Write the program through which the records can be updated?

0 Answers  

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

What are the types of schemas we have in data warehouse.

0 Answers  

What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,

Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 Answers  

For more Informatica Interview Questions Click Here
Categories