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.

Parameter and variable differences

2005

---

How an expression transformation differs from aggregator transformation?

989

---

Does an informatica transformation support only aggregate expressions?

970

---

how tokens will generate?

2153

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1926

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1024

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

1985

---

What are the issues you have faced in your project? How did you overcome those issues?

2289

---

What are the different options available for update strategy?

938

---

What is flashback table ? Advance thanks

1872

---

Explain the use of aggregator cache file?

1188

---

Explain what transformation and how many are there in informatica?

890

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4677

---

What is the use of source qualifier?

1070

---

How many dimensions are there in informatica?

1023

---