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
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to update a particular record in target with out running whole workflow?
Scheduling properties,whats the default (sequential)
What is decode in informatica?
How do you load unique records into one target table and duplicate records into a different target table?
What are the differences between joiner transformation and source qualifier transformation?
What is incremental aggregation?
What is meant by active and passive transformation?
In development project what is the process to follow for an etl developer from day1
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How can we use mapping variables in informatica?
What are session parameters ? How do you set them?
What are different types of transformations available in informatica?
tell me about your project functionality
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process