Interested to Buy Any Domain ? << Click Here >> for more details...
can you please explain me pre session and post session options?
- 3 Answers
- 7590 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 do u move the code from development to production?
What is the Rankindex in Ranktransformation?
what is the complex transformation you used in informatica
how we can load rejected record's at run time?(not through bad files)
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
How to convert flat file into xml file? How to tune joiner?
What is the use of source qualifier?
What is the Difference between DSS & OLTP?
How do we call shell scripts from informatica?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
Teradata 
