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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we get 1st record through Informatica(without sequence number).

989


what are the Methods For Creating Reusable Transformations?

649


What are the different transaction levels available in transaction control transformation?

679


Explain the scenario which compels informatica server to reject files?

658


What is incremental aggregation?

577






What is sq transformation?

668


What is the use of code page?

610


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2284


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7681


what is the -ve test case in your project.

1854


What is mapplet in informatica?

598


What is target load order?

807


How many input parameters can exist in an unconnected lookup?

994


How to delete duplicate row using informatica?

613


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4987