Answer / mike

session override is an option in informatica at session
level. Here we can maually give an sql query which is
issued to the database when the session runs. It is nothing
but over riding the default sql which is generated by a
particular transformation at mapping level.

correct me if i was wrong

Answer / guduri

i think mike is correect

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

What is router transformation

4 Answers   CSC,

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

Explain in detail scd type 2 through mapping.

0 Answers  

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,

---

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

---

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

Differentiate between mapping parameter and mapping variable?

1 Answers  

---

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

---