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 |
Why we use stored procedure transformation?
Mapplets can you use an active transformation in a mapplet,
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
What is degenerated dimention table?
What is decode in static cache?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
 Informatica Checkpoints
how i will stop my workflow after 10 errors