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 could be the possible resons of locks by user?

0 Answers  


In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,


whatis the default data driven operation in informatica

2 Answers  


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  


What is a repository manager?

0 Answers  






How is Data Models Used in Practice?

1 Answers  


in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

1 Answers   Cognizant,


what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,


Is there any model difference between ODS and DWH

2 Answers   Zensar,


How to do unit testing in informatica?

0 Answers  


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  


What is intricate mapping?

0 Answers  


Categories