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

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

Question Posted / ahalya inturi

Answer Posted / ahalya inturi

"Restart the session" . if the integration service has not issued at least one commit.
(or)
perform "Session Recovery" if the integration service has issued atleast one commit.
the I.S reads row id of last row commited from OPB_SRVR from repository table.
the I.S reads all the data from source , start processing from next row id..
we can perform session recovery when only target load type is normal. it can not support in bulk loading..

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data caches/ index caches?

1165

What is meant by lookup transformation?

1176

Which version configuration tool used in ur project?

3316

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1135

can you please explain me pre session and post session options?

7663

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1955

Enlist the differences between database and data warehouse.

1164

Performance tuning in UNIX for informatica mappings?

2620

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2168

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5780

How we can create indexes after completing the load process?

1197

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2476

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6275

What is the fact table?

1129

Did u used latest transformations of 8.6.0? for what?

1924