Answer / gsr

When you are using Flat File source you usually get the
header files separately from the data files. You may get
source data in more than one file. In such cases you give
the paths of all the data files in one file for eg say
list.txt. This file is called the list file. In the session
edit task window instead of giving the source filename you
enter the name of the list file - list.txt and in source
filetype you make it indirect.

Answer / shweta

When we use Flat file as a source we give the path of
directory where we store the file in Workflow.
But if we want data from multiple flat files then we put
the names of all flat files in a single file called as file
list.
In workflow mapping we give the path of list file and mark
the source filetype as INdirect as we are indirectly
accessing all the flat files.

Answer / arockia

In File list is it possible to create seperate target files
for each input file?? Ex: My list.yxy contains :
datafile1.dat,datafile2.dat. I want target file needs to be
created as datafile1.out, datafile2.out..

Please help...

Answer / shashiall

may b it is the path where our flat file is residing.we
have to give the total path at the place of the file
list...
plz...correct me if am wrong...

What is the scenario which compels informatica server to reject files?

1 Answers  

---

What does update strategy mean, and what are the different option of it?

1 Answers  

---

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

How can informatica be used for an organization?

1 Answers  

---

What is a mapplet/worklet in informatica?

1 Answers  

---

How to do unit testing in informatica?

1 Answers  

---

What are the popular informatica products?

1 Answers  

---

What is metadata reporter?

1 Answers   Informatica,

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1 Answers   TCS,

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

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

1 Answers  

---