How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain why we use partitioning the session in informatica?
is it possible to index the data in cache of lkp transformation ?
What are Dimensional table?
What is sorter transformation?
Can you generate sequence numbers without using the sequence generator transformation?
What is the meaning of up gradation of repository?
Informatica settings are available in which file?
How to configure mapping in informatica?
What is workflow monitor?
Sequence generator, when you move from develoment to production how will you reset
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
COM components can be used in Informatica
Explain the code page compatibility?
what is degenerated dimension?