Answer Posted / rajkumar bachu

This can be handled by using the file list in informatica.
If we have 5 files in different locations on the server and
we need to load in to single target table.In session
properties we need to change the file type as Indirect.

am taking a notepad and giving following paths and file
names in this notepad and saving this notepad as
emp_source.txt in the directory /ftp_data/webrep/

/ftp_data/webrep/SrcFiles/abc.txt
/ftp_data/webrep/bcd.txt
/ftp_data/webrep/srcfilesforsessions/xyz.txt
/ftp_data/webrep/SrcFiles/uvw.txt
/ftp_data/webrep/pqr.txt

In session properties i give /ftp_data/webrep/ in the
directory path and file name as emp_source.txt and file type
as Indirect.

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1055

---

Define update strategy?

1195

---

define galaxy repository in informatica

2206

---

Define enterprise data warehousing?

1183

---

Define filter transformation?

1082

---

What do you mean incremental aggregation?

1054

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2040

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

955

---

How can you differentiate between powercenter and power map?

1073

---

What is the sequence generator transformation in informatica?

1161

---

Explain the types of transformations?

1050

---

How can repository reports be accessed without sql or other transformations?

1203

---

What is source qualifier transformation in informatica?

991

---

What is the use of an aggregator cache file?

1181

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1936

---