What is the difference between Data Warehousing and Data Mining?
No Answer is Posted For this Question
Be the First to Post Answer
When do we go for the tools in the market?
1)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 ?
What is ROWID explain ?
What is etl process. How many steps etl contains explain with example?
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per 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?
What is a materialized view log?
what is the difference between shortcut of an object and copy of an object? compare them?
what is different between sequential batch and concurrent batch and which is recommended and why?
what is a worklet?
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.