how do u set partition points in the mapping?
how do u set partition points in the mapping?
What is etl process?
what is the difference between normal & bulk loading? and which one is recommended ? why?
Explain about round-robi?
When do we analyze the tables?
What is the main difference between peek stage and copy stage
Can u access a repository created in previous version of Informatica?
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 ?
Eliminating of duplicate records without using dynamic lookups
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?
how do u decide whether u need to do aggregations at database level or at Informatica level?
how do use session mapping parameters ?(in which transformation)