Please Help Members By Posting Answers For Below Questions
how to do aggregation (year wise quantity ) using only
source qualifier, the source is sql server date as datetime
data type and
target as flat file with year (string datatype)
flat filevalidation in informatica
1.Identify and discuss the problems which are occurred
during data quality verification for the single-source and
2.Testing has very important role in DWH. In ETL testing
phase, how can we perform the integration testing and
3.What are the perquisites of system testing and regression
testing in ETL phase?
how do u handle performance issues in Informatica . where
can u monitor the performance ?
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
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 is dynamic insert?
list and discuss two approaches for updation of target table
in Informatica and how they are different.
what are the concerns of OLTP and DSS systems?
what is the use of structures?how many nodes can u create in a
what is data modeling?
what is session partitioning?
what is the difference between cubes and package in cognos
architural difference between 7.1 workflow monitor and 8.1
Identifying the bottlenecks in various components of
Informatica and resolving them.