In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
Answer Posted / sukanta
The interviewer just check your knowledge about Informatica
Lookup Transformation.
If you disable cache you can't override the default sql query.
Follow Informatica Help.
Regards
Sukanta
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is the reusable transformation?
What is the maplet?
How can a transformation be made reusable?
Explain the features of connected and unconnected lookup.
What are the differences between source qualifier and joiner transformation?
Partition, what happens if the specified key range is shorter and longer
where to store informatica rejected data?
Write the program through which the records can be updated?
Which files are created during the session rums by informatics server?
How we can use union transformation?
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 is a connected transformation?
What is a dimensional model?
Please let me know how to make Data masking in informatica..
What is the function of look up transformation?