Answer / rahul

for n source we required n-1 joiner t/r.

ex: if we have 3 flat file dan we requried 2 joiner t/r

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

What is informatica metadata and where is it stored?

0 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,

---

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

---

Is it possible to use a client with different version than that of its Informatica server?

0 Answers  

---

---

Can we override a native sql query within informatica?

0 Answers  

---

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

6 Answers   IBM,

---

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers   TCS,

---

Enlist the various types of transformations.

0 Answers  

---

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

---

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---