Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain dynamic target flat file name generation in informatica
Can informatica load heterogeneous targets from heterogeneous sources?
Define pmcmd command?
What is joiner transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Define filter transformation?
What is the use of source qualifier?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain pushdown optimization and types in informatica
What is a transaction control transformation?
What is aggregator transformation in informatica?
What are the types of schemas we have in data warehouse.
What is the use of an aggregator cache file?
How do you convert single row from source into three rows into target?
