How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

1150

what is the use of server manager?

2069

where is the cache (lookup, index) created and how can you see it.

1981

where we cannot use sorter Transformation. if we use then we will not get correct data?

2152

A 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?

2185

What is the difference between round-robin partitioning and hash partitioning?

938

how do u extract data from different data sources explain with an example?

2216

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 ?

2078

how do u really know that paging to disk is happening while u are using a lookup transform?

2392

Explain what is etl process? How many steps etl contains explain with example?

849

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?

1834

What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

945

how do u handle performance issues in Informatica . where can u monitor the performance ?

4701

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1860

what is different between sequential batch and concurrent batch and which is recommended and why?

4882