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

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

Question Posted / balu024

Answers were Sorted based on User's Feedback



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

Answer / amedela chandra sekhar

1)Pre session:session execute data before loading the data into target.
2) post session :session execute data after loading the data into target

Is This Answer Correct ?    5 Yes 2 No

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

Answer / gm

Pre_Session and Post_Session are availble in
Source_Qualifier and Target.
In SQ:
Pre_Session:(Pre_SQL)
Something we can do before reading data form Source
Ex: delete some temp files
Pre_Session:(Post_SQL)
Something we can do after reading data form Source
Ex: clean the data according to business requirement.

Is This Answer Correct ?    3 Yes 1 No

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

Answer / abhinaw prakash

Pre session and post session.

Example: if we want to use bulk mode loading on index tables
it'll fail.

So its something like we can drop the index in pre session
command and again recreate the indexes once the data has
been loaded in post session.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

why we use source qualifier transformation?

16 Answers   Accenture,

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  

What are mapping parametres and variables in informatica?

6 Answers   TCS,

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

what are the difference between Informatica 7.1 and 8.1?

6 Answers  

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 Answers  

how many types transformations supported by sortedinput?

4 Answers  

For more Informatica Interview Questions Click Here
Categories