Answer / nagapuri

It can recognize by ODBC or FTP Connections.

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

How to delete the data in the target table after loaded.

3 Answers   TCS,

---

What does refresh system mean, and what are its distinctive choice?

0 Answers  

---

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

1 Answers   Hexaware,

---

tell me the push down optimization

2 Answers   Wipro,

---

How to update records in Target, without using Update Strategy?

3 Answers  

---

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

---