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

HOW DO YOU CONNECT TO REMOTE SERVER ?

1 Answers   TCS, Patni,


What are the different types of Type2 dimension maping?

2 Answers   CTS,


what is difference between mapping and mapplet ?

2 Answers   TCS,


How to eliminate duplicates in FF and oracle both

3 Answers   CSC,


1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,






Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,


what is the flat file partition and where have to specify it

1 Answers   TCS,


What is critical mapping?

2 Answers  


What is an aggregator transformation?

0 Answers  


Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  


What aer the out put files that the informatica server creates during the session running?

4 Answers  


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,






Categories