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
Differentiate between sessions and batches?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the differences between joiner transformation and source qualifier transformation?
Explain target update override in informatica
What is an aggregator transformation?
Describe expression transformation?
What is a repository manager?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
What is the function of union transformation?
What is the difference between informatics 7x and 8x and what is latest version?
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is the use of source qualifier?
What are the different types of transformation available in informatica.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is data transformation manager process?
