Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 18267 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 ? | 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 flat file override?
what is left outer join?
Can informatica load heterogeneous targets from heterogeneous sources?
wht is cdc?how to use it in creation of mappings?
Why sorter is an active transformation?
what r the values tht r passed between informatics server and stored procedure?
What is data movement mode in Informatica and difference between them?
what is degenerated dimension
what is confirmed dimension?
Two different admin users created for repository are ______ and_______
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
how to load duplicate row in a target
Teradata 
