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
Define mapping and session?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Separate from an archive server and a powerhouse?
What are the types of presistent cache in look up tr.
Repository user profiles
What are the main features of Oracle 8i with context to datawarehouse?
Explain the informatica workflow?
Target increases every day even though no new record was inserted
What are some examples of informatica etl programs?
In which transformation you cannot drag ports into it?
What are the different ways to implement parallel processing in informatica?
Implementation methodology
what is the Default Source Option For Update Strategy Transformation?
What are the different options available for update strategy?
How we can create indexes after completing the load process?