How do you migrate data from one environment to another?
What is aggregate awareness?
How to update records in Target, without using Update Strategy?
Is it possible to create multiple domains on a single Informatica server?
What is informatica powercenter repository?
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How to create a non-reusable instance of reusable transformations?
Design a mapping to load a target table with the following values from the above source?
What is a connected transformation?
what are the settiings that u use to cofigure the joiner transformation?