Please Help Members By Posting Answers For Below Questions
how do use session mapping parameters ?(in which transformation)
where are the log files generally stored.Can you change the
path of the file.what can the path be?
How can you use an Oracle sequences in Informatica ? You
have an Informatica sequence generator transformation also.
which one is better to use?
what are the facilities provided by data warehouse to
Identifying the bottlenecks in various components of
Informatica and resolving them.
what make u disappointmnets in u r career
how can i text accracy of ETL migration? i am very new to
data warehousing. we are writing ETL scripts using
SCRIPELLA tool. how can i test the correctness of data.
and we are generating reports using pentaho . is there any
easy way to test the pentaho. how can test these ETL
scripts written in scriptella?
thanks in advance
what are the reports created in mm and sd side using sap bw in
a project? name some of them and explain the requirement?
what are Lookup caches options? Including persistent caches.
how many maximum session supports to multiload in teradata ??
how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
how do u identify the changed records in operational data?
what is the use of structures?how many nodes can u create in a
what is an ETL or ETT? And what are the different types?
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