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
- 18182 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 |
in static and dynamic which one is better
Briefly explain the aggregator transformation?
Quickly characterize reusable change?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
Write the unconnected lookup syntax?
differences between service based and product based?
When we are using Dynamic Cache,which options we will select in session level?
What are roles and groups and benefits of using them?
what is $$$$?
Write the program through which the records can be updated?
What are the new features of informatica 7.1?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
Teradata 
