Interested to Buy Any Domain ? << Click Here >> for more details...
In Lookup transformation a sql override should be done and
disable
the cache how do you do this procedure?
- 1 Answers
- 8036 Views
- Wipro, I also Faced
- E-Mail Answers
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
Enlist the tasks for which source qualifier transformation is used.
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How does the aggregator transformation handle null values?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain the code page compatibility?
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 pmcmd command?
Design time, run time. If you don't create parameter what will happen
explain abt ur project architecture?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
what is SDLC way of code development?
How can we improve session performance in aggregator transformation?
On which transformations you created partitions in your project?
Partition, what happens if the specified key range is shorter and longer
