Interested to Buy Any Domain ? << Click Here >> for more details...
How to add source flat file header into target file?
- 3 Answers
- 9185 Views
- Logica CMG, I also Faced
- E-Mail Answers
Answer Posted / venkatanarayana manam
First Open the session which contains source/target as Flat file edit the mapping tab-->properties-->Enable Add Currently Processed Flat File Name Port
If selected, a port specifying currently processed file name will be added to the source widget.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Enlist the various types of transformations.
can you please explain me pre session and post session options?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Different circumstance which drives informatica server to expel records?
How many numbers of sessions can one group in batches?
What are the advantages of using informatica as an etl tool over teradata?
How does a rank transform differ from aggregator transform functions max and min?
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
Explain the types of lookup transformation?
What is the use of transformation?
Differentiate between router and filter transformation?
What is Session and Batches?
Where do we use mapping variables in informatica?
Explain the features of connected and unconnected lookup.
Mention few advantages of router transformation over filter transformation.
