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
How will the document be delivered to me?
Separate from an archive server and a powerhouse?
How we can use union transformation?
What is the use of code page?
How you prepared reports for OLAP?
How can you increase the performance in joiner transformation?
What is meant by active and passive transformation?
How to implement security measures using repository manager?
What is event and what are the tasks related to it?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is difference between a gateway node and worker node?
How to load data in informatica ?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
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 ?
What are the differences between source qualifier and joiner transformation?