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

Answer / ravi

Above answer given by Nagaraju works fine.
We need to goto workflow,open Task properties
Goto mappings Tab, then go to source properties. Change
source file type attribute to 'indirect' and give source
file name attribute value to file name that contains list
flat files to be loaded(complete path).

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

What is predefined event?

1 Answers  

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

What are the limitations of joiner transformation?

0 Answers   Informatica,

---

What is workflow monitor?

0 Answers  

---

What are the modules in Power Center

0 Answers  

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

How can you validate all mappings in the repository simultaneously?

0 Answers  

---

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

---

How to update records in Target, without using Update Strategy?

3 Answers  

---