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

What is difference between stored procedure transformation and external procedure transformation?

2 Answers  


how to get flatfile containg 10 records half records one target another half another target

2 Answers  


What is the procedure to load the fact table.Give in detail?

1 Answers  


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?

5 Answers   Wipro,


what is the difference between Informatica7.1 & informatica 8.1

4 Answers  






What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,


How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,


I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  


In update strategy target table or flat file which gives more performance ? why?

7 Answers  


version controlling in informatica?

3 Answers  


How will you convert rows into columns or columns into rows

1 Answers  


Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,


Categories