what is the difference between date cache and lindex cache?
Answer / hari
index cache contains all port values which are participated
in given condition.
data cache contains all port values which are not
participated in given condition
| Is This Answer Correct ? | 1 Yes | 0 No |
SCD2 will work on only dimension tables as well as fact Table?
How to know informatica conslole password??
Hi, Lookup() is what kind of join ?
How to increase performance without changing anything in mapping.( In prod)
0 Answers IBM, Saama Tech, Wipro,
What are dimensions?
What is fact? What are the types of facts?
how do use session mapping parameters ?(in which transformation)
how do u implement unconn.stored proc. in a 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?
where we cannot use sorter Transformation. if we use then we will not get correct data?
how do u automate Extraction process?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys