Answer Posted / srinu

passive transformation :
unable to keep a condition,Expressions only.

active transformation :
unable to keep a Expressions,condition only.

Based on Transformation functionality.

Name the different lookup cache(s)?

1158

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2252

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1089

---

Explain sql transformation in script mode examples in informatica

1045

---

Differentiate between Load Manager and DTM?

2093

---

Mention few power centre client applications with their basic purpose?

891

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1913

---

How can we delete duplicate rows from flat files?

1162

---

How to load the data from a flat file into the target where the source flat file name changes daily?

1004

---

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.

2797

---

What are junk dimensions?

1019

---

What is aggregator transformation in informatica?

896

---

How to implement security measures using repository manager?

1082

---

Describe an informatica powercenter?

1035

---

Explain incremental aggregation in informatica

1064

---