can you please explain me pre session and post session options?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention few power centre client applications with their basic purpose?

525


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7662


How can we use mapping variables in informatica?

592


What are the uses of etl tools?

634


What is the difference between source qualifier transformations source filter to filter transformation?

569






Have you worked with/created Parameter file

1222


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1689


How many numbers of sessions can one group in batches?

611


Describe the impact of several join conditions and join order in a joiner transformation?

632


What is joiner change?

662


State the limitations where we cannot use joiner in the mapping pipeline?

541


What is expression transformation?

621


What is a surrogate key?

555


Explain sessions and how many types of sessions are there?

574


Define joiner transformation?

586