how would u estimate the size of Lookup transform data and
index cache?
Answer Posted / san
Just run the session once, and check for the session logs
you will get the DATA and IDX cache size.
Regards,
San
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the use of structures?how many nodes can u create in a structure?
what are the reports developed in sap bw project and what is the requirement for developing it?
what are the facilities provided by data warehouse to analytical users?
what do u do when DB time takes more?in sap bi
how to connect to a flatfile through ftp in informatica
how do u identify the changed records in operational data?
Do we need an ETL tool? When do we go for the tools in the market?
what are the concerns of OLTP and DSS systems?
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
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what is Forward,Reverse and Re_engineering?
what are the reporting tools and difference between them?
Informatica 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?
What is a materialized view log?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?