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



we have a parameter file in Unix location where we have .txt files and those file will be used as ..

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

we have a parameter file in Unix location where we have .txt files and those file will be used as ..

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

Post New Answer

More Informatica Interview Questions

Explain how many types of dimensions are available in informatica?

0 Answers  


what is left outer join?

3 Answers   L&T,


How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,


what is work of PUSH DOWN option

2 Answers   Wipro,






What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,


what is normalizer transformation?

4 Answers   Wipro,


What is a joiner transformation?

0 Answers  


Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,


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

4 Answers   Wipro,


Mention some types of transformation?

0 Answers  


How is Data Models Used in Practice?

1 Answers  


Categories