Answer Posted / gopal
$$ - is used for Parameter...see the below example
select a,b,c from <table> where <table>.date-$$date_filter
when you define parameter file in the src File directory
and this should be given in session, if in parameter file
if you give 10, then above query will be as below
select a,b,c from <table> where <table>.date-10
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many numbers of sessions can one group in batches?
Write the different tools in the workflow manager?
What are the different clients of powercenter?
What is sequence generator transformation in informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what is mean by complex business rule ?
What does refresh system mean, and what are its distinctive choice?
Why filter transformation is an active one?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is powercenter on grid?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to extract sap data using informatica?
explain about unit testing? in real time?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Write the advantages of partitioning a session?