Answer / 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.

Answer / chandrababu naidu

by using a concept called filemerging
we will give the path of all files in a sinle file
and in session properties select file type is indirect

Answer / jvdwhinfo

Hi Guys,

First of all create a new flat file and paste the location
of all the flat files in that newly created flat file.
Now import the source definition using "Import from file"
and define the mapping.
And assign the session properties as indirect file type of
loading and give the location of the newly created file.

This should do and please let me know if you want me to
discuss further.

Thanks,
James

Answer / alok

Phani, it will be great if u can elaborate this.

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  

---

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,

---

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

---

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

1 Answers   CTS,

---

expain about the tune parameters?

0 Answers   TCS,

---

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---