When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.
3 13116list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
2 7288what is different between sequential batch and concurrent batch and which is recommended and why?
4922A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
22251)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
2108Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
3757
how do u handle performance issues in Informatica . where can u monitor the performance ?
What do you understand by the term ‘transformation’?
What is data cleaning?
what is the difference between cardinality and Nullability?
How many steps etl contains?
how does the server recongnise the source and target databases.Elaborate on this
When do we go for the tools in the market?
How many types of transformations supported by sorted input?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
Explain the key challenges that you face while performing etl testing.
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
if i have a query as flat file how can we load data to target table
How many steps etl contains explain with example?
what are the reporting tools and difference between them?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?