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 13137list 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 7316what is different between sequential batch and concurrent batch and which is recommended and why?
4928A 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?
22301)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
where is the cache (lookup, index) created and how can you see it.
What are the names of the layers in etl?
Mention few test cases and explain them?
State the differences between shortcut and reusable transformation
Explain about enterprise scalability and roi of data integration suite?
Compare etl & elt?
what is session partitioning?
What is tracing level and what are the types?
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
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
What is a staging area? What is the purpose of a staging area?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
what make u disappointmnets in u r career
SCD2 will work on only dimension tables as well as fact Table?
What are three tier systems in etl?