can you please explain me pre session and post session options?
- 3 Answers
- 6623 Views
- BTBP, I also Faced
- E-Mail Answers
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 |
How to delete duplicate row using informatica?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
what are the Methods For Creating Reusable Transformations?
what is the difference between onsite & client site?
what is flat file override?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
What is the difference between router and filter?
What is data merging,data cleansing,sampling?
Different types of Power center errors?
What is persistent lookup cache?
After we make a folder shared can it be reversed?Why?
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
Teradata 
