we have a parameter file in Unix location where we
have .txt files and those file will be used as source in
informatica.
I cannot use source file name directly as file name will
keep on changing in unix location.
I need to define $$InputFile as parameter.
Can anybody send me the parameter file and the steps to
handle this.
Answers were Sorted based on User's Feedback
Answer / mubbasir
Note : Use $InputFileabc and not $$inputfileabc
[folder name.WF:workflow name] or [folder name.session
name]
$InputFileName=
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / bhasker
Hi sure
All u need to do is
Create a parameter file name
eg:
basu.txt(prm)
[foldername.sessname]
$$inputfileabc.domainname&path(root/aaa/bbb/prm.txt
now in session properties
give ths parameter file name: basu.txt
& under mapping tab in session properties
give remove all other options
have only input conn:$$inputfileabc
now u could run the session
now it would go ahead & find the source path
| Is This Answer Correct ? | 3 Yes | 2 No |
what is curr val use for in sequence generator?
what is a transforamation?
How to view and Generate Metadata Reports?
differences between service based and product based?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
What is meant by query override?
Why use shortcuts(Instead of making copies).
How to eliminate 1st and last rows from the source and load the inbetween rows.
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
What are events in workflow manager?