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.
- 2 Answers
- 17454 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
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 ? | 10 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 |
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
What all are steps in up gradation of Informatica server?
What is joiner cache?
What are the different types of schemas?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
What is main use of mapplet?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
What is a shortcut and copy in Informatica and how two are different with each other?
Define error Threshold?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
What exactly mentioned in High level design document.can somebody explain me sequentialy.
Teradata 
