explain about informatica server architecture?
Answer / ramu
informatica server moves data from source to target based on
workflow and mapping metadata stored in repository.
| Is This Answer Correct ? | 2 Yes | 3 No |
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
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
performance wise which one is better in joiner and lookup transformation
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
Slowly changing dimensions, types and where will you use them
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the new features of Power Center 5.0?
Which transformation should u need while using the cobol sources as source defintions?
what are the unix commands to start the wrk flow ?
Tell me about Propagate functions in informatica
What are the different types of Type2 dimension maping?