Answer Posted / giri
Lookup connected,unconnected and Passive transformation. Looking for related values and inserting flake values.
Inserting Flag value
0 - No Change
1 - Insert
2 - Update
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we create a node as a gateway node and the same node can be assigned to a grid?
How many input parameters can exist in an unconnected lookup?
Explain the etl program with few examples.
What are the static cache and dynamic cache in informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
Did u used latest transformations of 8.6.0? for what?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Enlist few areas or real-time situations where informatica is required.
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.
What are the performance considerations when working with aggregator transformation?
Where is metadata stored?
What does “tail –f” command do and what is its use as an Informatica admin.
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is transformation?
