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
Difference between Target-based loading and constraint-based loading?
Sequence generator, when you move from develoment to production how will you reset
Tell me about MD5 functions in informatica
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?
What are the issues you have faced in your project? How did you overcome those issues?
Briefly describe lookup transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain dynamic target flat file name generation in informatica
How to join three sources using joiner? Explain though mapping flow.
What is enterprise data warehousing?
How are indexes created after completing the load process?
What are batches?
What are the performance considerations when working with aggregator transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
