Interested to Buy Any Domain ? << Click Here >> for more details...
when we create source as oracle and target as flat file, how
can i specify first row as column in flat file?
- 1 Answers
- 5911 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
In case of target as a flat file, the header names will be
defined during the target definition. The Header names can
be specified using the option called 'Load Header' Option
in Mapping tab of Session. There are three options 1. for
no headers, 2. header from target definition and 3. Load
from Command. based on these we can load the header names
accordingly.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the new features of Power Center 5.0?
Define mapping and session?
What do you mean by enterprise data warehousing?
What is the Process to creating lookup transformation in informatica
How to extract the informatica rejected data?
what is mean by complex business rule ?
How do you use reject loader.
Define pmcmd command?
What is powercenter on grid?
what is INFORMATICA TESTING process
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
Different circumstance which drives informatica server to expel records?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the components of the workflow manager?
Design time, run time. If you don't create parameter what will happen
