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

Why we use stored procedure transformation?

4 Answers  


Mapplets can you use an active transformation in a mapplet,

1 Answers  


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

0 Answers   TCS, Wipro,


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  


Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,


What is degenerated dimention table?

7 Answers   Patni,


What is decode in static cache?

0 Answers  


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

0 Answers  


 Informatica Checkpoints

0 Answers   DELL,


how i will stop my workflow after 10 errors

1 Answers   HP,


Categories