Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
What is sq transformation?
What is lookup transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the need of etl tools?
How to do unit testing in informatica? How to load data in informatica ?
What is a passive transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is standalone command task?
When do you use sql override in a lookup transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain 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?
How to join three sources using joiner? Explain though mapping flow.
