Answer / anoymous

This can be done by File list or File repository. Create
rep.txt file list in that write all the paths of the i lac
flat files.
in session level set the following attributes
source file name indirect
source file directory filelist path address
source file name rep.txt

Answer / mike

@ above answer
well its source filetype which need to be indirect

Answer / usha

By using list file concept we can process 1lac files.
list of files should have same struture.
then only we can process all file.another importent thing
we should set source file type as indirect

in session level set the following attributes
source file type indirect
source file directory filelist path address
source file name file_s.lsh

Answer / manojkumar

I think Source file name should end with .lst extension
like "filename.lst"

And this list file shoud include all 1Lac file names.
Remaining all same as above only.

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,

---

How do you convert single row from source into three rows into target?

0 Answers  

---

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

---

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  

---

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

---

Which kind of index is preferred in DWH?

2 Answers  

---

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 Answers  

---

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

---

what is distinct

4 Answers  

---

Using Informatica Visio to generate mappings. I am getting error "Table Definition Not Found Exception Error" while importing the template.

1 Answers  

---

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

---