what is pmrep command?
No Answer is Posted For this Question
Be the First to Post Answer
When do we analyze the tables?
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 are the different etl testing categories as per their function?
what is the difference between OLTP database and data warehousing database?
Explain about hash partitioning?
what is dynamic insert?
What is tracing level? How many types of transformations supported by sorted input?
Explain etl?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how do u set the size of block buffer?
if i have a query as flat file how can we load data to target table
Eliminating of duplicate records without using dynamic lookups