Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 18188 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How can one identify whether mapping is correct or not without connecting session?
What is the status code in stored procedure transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
can anyone explain me about retail domain project in informatica?
Briefly describe lookup transformation?
what is mean by complex business rule ?
What is the meaning of up gradation of repository?
How can we remove the duplicates from flat file source?
How to create the source and target database connections in server manager?
How to extract the informatica rejected data?
How to implement security measures using repository manager?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
