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.
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 |
What is difference between stored procedure transformation and external procedure transformation?
how to get flatfile containg 10 records half records one target another half another target
What is the procedure to load the fact table.Give in detail?
source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?
what is the difference between Informatica7.1 & informatica 8.1
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
In update strategy target table or flat file which gives more performance ? why?
version controlling in informatica?
How will you convert rows into columns or columns into rows
Limitation of REPLACESTR. Is there any character limitation to it.