Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

---

How to delete the (flat file) data in the target table after loaded.

2 Answers   TCS,

---

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---

---

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

---

What is a connected transformation?

0 Answers   Informatica,

---

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

What is hash partition?

2 Answers  

---

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers   IBM, TCS,

---

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

4 Answers  

---