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 11990list 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 6566what is different between sequential batch and concurrent batch and which is recommended and why?
4650A 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?
20121)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 ?
1857Informatica 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?
3492
What is full load & incremental or refresh load?
Explain about power designer data modeling software?
when will use SQL override in a lookup transformation?
what do u do when DB time takes more?in sap bi
What do you understand by active and passive transformations?
What is staging area referring to?
how do u set partition points in the mapping?
how many steps are there in etl process?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what is an ETL or ETT? And what are the different types?
How many types of transformations supported by sorted input?
Can we create Hierarchies in generic datasources?
Is apache nifi an etl tool?
What is lookup table in etl testing?
What is initial load and what is full load?