Answer Posted / venkat

Hi Mukesh, Can an you please send informatica
certification MailId: vsubbareddy32@gmail.com

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2000

---

What is a shortcut and copy in Informatica and how two are different with each other?

1134

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2001

---

what is the Default Source Option For Update Strategy Transformation?

1170

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7274

---

Explain direct and indirect flat file loading (source file type) - informatica

1269

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7120

---

Can we override a native sql query within informatica?

989

---

Which is the t/r that builts only single cache memory?

1130

---

Briefly describe lookup transformation?

985

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2077

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1083

---

Can we create a Integration service without a Repository service and vice versa?

1176

---

What is xml source qualifier transformation in informatica?

1177

---

What are data-driven sessions?

1147

---