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
How big was your fact table
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Design a mapping to load a target table with the following values from the above source?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Why filter transformation is an active one?
What are the advantages of using informatica as an etl tool over teradata?
How are the sources and targets definitions imported in informatica designer?
What is the sql query overwrite in source qualifier in informatica
Separate from an archive server and a powerhouse?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Can we override a native sql query within informatica?
What do you mean by blocking transformation?
What is an aggregator transformation?
