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 11597list 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 6321what is different between sequential batch and concurrent batch and which is recommended and why?
4537A 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?
19051)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 ?
1754Informatica 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?
3398
Two default user groups created in the repository are____and_____.
Explain the difference between etl tool and olap tools?
Explain what is etl process? How many steps etl contains explain with example?
Can u access a repository created in previous version of Informatica?
what is the meant by Normalization and de-normalization?
What are materialized views & where do we use them?
what is Forward,Reverse and Re_engineering?
explain the methodology of Data Warehousing?(Polaries)
What is a mapping?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
State the differences between shortcut and reusable transformation
what is granularity in Data ware House?
Do we need an ETL tool? When do we go for the tools in the market?
what is a worklet?
What are the differences between sql override and update override?