we have a parameter file in Unix location where we
have .txt files and those file will be used as source in
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
Answers were Sorted based on User's Feedback
Answer / mubbasir
Note : Use $InputFileabc and not $$inputfileabc
[folder name.WF:workflow name] or [folder name.session
|Is This Answer Correct ?||10 Yes||1 No|
Answer / bhasker
All u need to do is
Create a parameter file name
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|
what are the unix commands to start the wrk flow ?
What is galaxy shema
Explain transaction control transformation in informatica
What is router transformation
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are set operators in Oracle
What is the status code?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,