Answer Posted / phani

By using File List we can Merge more than one Flat file.
when we are importing more than one flat file we should Set
the Source Property as INDIRECT,where default property ll
have DIRECT. and we should give the file,which ll have the
adresses of all the Flat files which we are going to merge.

What are the components of workflow manager?

1074

---

Why update strategy and union transformations are active? Explain with examples.

1219

---

What is the difference between source qualifier transformations source filter to filter transformation?

1032

---

What is source qualifier transformation in informatica?

989

---

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.

2847

---

What can we do to improve the performance of informatica aggregator transformation?

1075

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1022

---

Enlist the various types of transformations.

1020

---

What does reusable transformation mean?

1118

---

What is exclusive and normal mode for repository services?

1122

---

Enlist the advantages of informatica.

1044

---

explan ur project architecture?

2042

---

Briefly define a session task?

1105

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1273

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1789

---