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.
Answer Posted / 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 |
Post New Answer View All Answers
Can you generate sequence numbers without using the sequence generator transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What is blocking transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is index?how it can work in informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Differentiate between joiner and lookup transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What do think which one is the better joiner or look up?
Repository user profiles
is it possible to index the data in cache of lkp transformation ?
How can a transformation be made reusable?
What's the layout of parameter file (what does a parameter file contain?)?
What is DR strategy for Informatica project?
What is a mapplet/worklet in informatica?