can you please explain me pre session and post session options?
- 3 Answers
- 6624 Views
- BTBP, I also Faced
- E-Mail Answers
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
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
While migrating the data from one environment to another environment how would you manage the connections?
What is the status code in stored procedure transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is a router transformation?
What is intricate mapping?
What is option by which we can run all the sessions in a batch simultaneously?
What are the different options available for update strategy?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Is it possible to revert a global repository to local one and why?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
Separate from a database, an information bazaar, and an information stockroom?
What are the performance considerations when working with aggregator transformation?
