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

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

without using emailtask how will send a mail from informatica?

3 Answers  


What is confirmed dimension with scenario

1 Answers   HCL,


What are different types of transformations available in informatica?

0 Answers  


What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  


Is it possible to update the target table with PK?

1 Answers   TCS,






In joiner, how to load Master table in Target?

2 Answers  


what is diff between grep and find

3 Answers   IBM, iFlex,


How can we improve session performance in aggregator transformation?

0 Answers   Informatica,


How to recover the standalone session?

2 Answers  


"Change cache" in Informatica ?

2 Answers  


Quickly characterize reusable change?

0 Answers  


How do you load first and last records into target table?

0 Answers  


Categories