Answer / varun4db

For source side we can push by overriding the query..so that
integration service pass the query to database... Please
correct me if am wrong..!!!

Answer / venubyna1

Asession configure for push down optimization to Increase
the session performance.
The I.S Analyze the mapping and T/r logic and determine T/r
logic it ll send to the source or Tager data base
I.S is convert the T/r logic into SQL then send to the data
base server
there r 3 types
1. Source side push down
2.Target side push down
3.fullside push down

How can u stop a batch?

2 Answers  

---

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

---

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

---

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

---

Explain the different lookup methods used in informatica?

0 Answers  

---

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

---

How mapping parameter and variable works

1 Answers  

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

---

What is domain in terms of informatica?

0 Answers  

---

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

2 Answers   CTS,

---

What is data merging, data cleansing and sampling?

6 Answers   Satyam,

---