Answer Posted / urs

If you want Flat file to Excel format, convert it into excel
format and save it as .CSV(comma separate value) format.It
is having capacity 10lakhs records..

How many ways are there to do 'remove duplicate records in informatica'?

1067

---

How can we update a record in the target table without using update strategy?

1206

---

What is a sequence generator transformation?

1075

---

How many numbers of sessions can one group in batches?

1105

---

Different qualification between a related rotate toward the sky and isolates look upward?

1041

---

Can anyone tell me the new features in Informatica 9 Version?

2216

---

What are the differences between source qualifier and joiner transformation?

1137

---

What is joiner transformation?

1067

---

what is the -ve test case in your project.

2462

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1332

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1734

---

What is the session task and command task?

1115

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2481

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2109

---

Is there any way to read the ms excel datas directly into informatica?

1073

---