can you please explain me pre session and post session options?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
without using emailtask how will send a mail from informatica?
What is confirmed dimension with scenario
What are different types of transformations available in informatica?
What is the difference between a shortcut of an object and copy of an object? Compare them.
Is it possible to update the target table with PK?
In joiner, how to load Master table in Target?
what is diff between grep and find
How can we improve session performance in aggregator transformation?
How to recover the standalone session?
"Change cache" in Informatica ?
Quickly characterize reusable change?
How do you load first and last records into target table?