Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

What is lookup change?

0 Answers  

---

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

---

How to load relational source into file target?

3 Answers   IBM,

---

What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

---

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

Define mapping and session?

0 Answers   Informatica,

---

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers   IBM,

---

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

---

What is target designer and target load order?

0 Answers  

---

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

---