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 11213list 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 6102what is different between sequential batch and concurrent batch and which is recommended and why?
4445A 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?
18151)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 ?
1662Informatica 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?
3306
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
State the differences between shortcut and reusable transformation
What are dimensions?
Explain about etl data integration software?
can be used COM component in Informatica ?
what are the facilities provided by data warehouse to analytical users?
what is data modeling?
how do use session mapping parameters ?(in which transformation)
Explain do we need an etl tool? When do we go for the tools in the market?
Explain do we need an etl tool?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
what is the use of server?
SCD2 will work on only dimension tables as well as fact Table?
In Which Transformation We Can Use Having Clause In Informatica?
what is pmrep command?