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 13136list 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 7313what is different between sequential batch and concurrent batch and which is recommended and why?
4927A 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?
22291)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 ?
2116Informatica 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?
3766
how do u set partition points in the mapping?
Explain etl?
List few etl bugs?
what is the difference steps for data modeling?
What are the various tools used in etl?
what is pmrep command?
if i have a query as flat file how can we load data to target table
what is the difference between cubes and package in cognos
how do u set partition points in the mapping?
What is abap? What are idocs?
What are cubes and olap cubes?
how many maximum session supports to multiload in teradata ??
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Do we need an etl tool?
what is session partitioning?