Interested to Buy Any Domain ? << Click Here >> for more details...
can you please explain me pre session and post session options?
- 3 Answers
- 7663 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 |
"Change cache" in Informatica ?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
Diffrence between 7.1,8.1 and 8.6
What are the limitations of joiner transformation?
can a port in expression transf be given the name DISTINCT
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
During the running session, output files are created by informatica server. Enlist few of them.
Differentiate between source qualifier and filter transformation?
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
what is distinct
What is source qualifier transformation?
how to load only the first and last record of a flat file into the target?
Teradata 
