when will use SQL override in a lookup transformation?
Two default user groups created in the repository are____and_____.
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?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
how do u handle performance issues in Informatica . where can u monitor the performance ?
list and discuss two approaches for updation of target table in Informatica and how they are different.
where are the log files generally stored.Can you change the path of the file.what can the path be?
where is the cache (lookup, index) created and how can you see it.
what are the session parameters? How do u set them?
how do use session mapping parameters ?(in which transformation)
what is dynamic insert?
what is pmrep command?
what happens if the info.server doesn't find the session parameter in the parameter file?
what are Lookup caches options? Including persistent caches.
Difference between flat files and relational sources?
