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

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.

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.

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  

---

What is informatica powercenter repository?

0 Answers  

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

---

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

Explain reference cursor?

1 Answers  

---

Issue with Update override at Target table in Informatica.

2 Answers  

---

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

how to remove staging area

1 Answers  

---

how to connect two or more table with single source qualifier?

4 Answers   IBM,

---