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

Difference Between ETL & ELT?

1 Answers   TCS,

---

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

---

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---

difference between shortcut and reusable transformation?

2 Answers  

---

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

How you know when to use a static cache and dynamic cache in lookup transformation?

0 Answers  

---

State the differences between sql override and lookup override?

0 Answers  

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers  

---

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

7 Answers   Cap Gemini,

---