Please Help Members By Posting Answers For Below Questions
when will use SQL override in a lookup transformation?
Assume u have a 24CPU machine with 24GB RAM, suggest how u
would like to configure Informatica ,like number of
concurrent sessions, RAM requirements etc,max partitions
that u would permit per mapping.
how do use session mapping parameters ?(in which transformation)
How can you use an Oracle sequences in Informatica ? You
have an Informatica sequence generator transformation also.
which one is better to use?
Can anyone explain me a scenario from banking and
finance...more precisely a mapping
hoe to access second value in mapping parameter if it is having more than one value
diff b/w dwh & data mart
diff b/w star schema & snow flake schema
diff b/w fact table & dimension table
what are the contents in requirement specification
what are the docs needed for testing
draw ur proj architecture
what are the types in error loging?
what is the difference steps for data modeling?
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
flat filevalidation in informatica
where is the cache (lookup, index) created and how can you
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
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?