Interested to Buy Any Domain ? << Click Here >> for more details...
can you please explain me pre session and post session options?
- 3 Answers
- 7451 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 |
What are the databases that informatica can connect to windows?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What does update strategy mean, and what are the different option of it?
What is the sql query overwrite in source qualifier in informatica
What is a router transformation?
What is the Difference between sorter and aggregator?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
How to load data in informatica ?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
Teradata 
