Answer Posted / nagaraju bhatraju

if your flat file are of same structure then analyze any
one of the file in sourceanalyzer of informatica,and
proceed with mapping development, hence you will have only
one mapping, but make all other flat file entries into
other file along with their exact path of files and save
this indexfile or file with all files entires with .dat.

and give this file name in source file directory or source
file and change load type from direct to indirect, hence
all the 365 files will be loaded in to the singe target ,
with single mapping , this concept will be called as file
list or file repository .

How can we use batches?

1004

---

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

987

---

What are the prerequisite tasks to achieve the session partition?

1224

---

Where are the source flat files kept before running the session?

1056

---

EXL informatica Questions

1357

---

What do you understand by a term domain?

1108

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1088

---

What do you mean by enterprise data warehousing?

1037

---

Briefly explain the aggregator transformation?

983

---

Define enterprise data warehousing?

1180

---

What is blocking transformation?

1123

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7180

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1952

---

What is a predefined event?

1078

---

What does reusable transformation mean?

1116

---