tell me the informatica architecture
Answer / akhil4
infromatica product known as informatica power center.it consist of 3components
1.informatica power center client tools
in this we have
a.designer
b.repository manager
c.work flow manager
d.work flow monitor
2.informatica power center repository
3.informatica power center server
| Is This Answer Correct ? | 5 Yes | 7 No |
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what type of transformation is not supported by mapplets?
What do you mean by blocking transformation?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
what is index?how it can work in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
.prm wirh repalce .txt is possible?
How do you load unique records into one target table and duplicate records into a different target table?
Explain the flow of data in Iinformatica?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
HOW TO DELETE A RECORD FROM FLAT FILE