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
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can we override a native sql query within informatica?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Which transformation should we use to normalise the COBOL and relational sources?
Where can we find the throughput option in informatica?
can anyone explain me about retail domain project in informatica?
What is dynamic cache?
Explain the different lookup methods used in informatica?
What is rank transform?
What do you mean by channel change?
can we override a native sql query within informatica? How do we do it?
How to join three sources using joiner? Explain though mapping flow.
EXL informatica Questions
What is a dimensional model?
What is a passive transformation?