Please Help Members By Posting Answers For Below Questions
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 identify the changed records in operational data?
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.
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 data modeling?
explain the methodology of Data Warehousing?(Polaries)
Knowledge on what are the improtant characteristice that we
need ot consider while developing an ETL Code
Can we create Hierarchies in generic datasources?
What is Data Vault???
I've a mapping with flat file source
The target update override property for the target table is
There is no update strategy between source and target.
Also The session has the target properties as
Insert , Update as update options checked.
Does this mean that recs will be inserted only and the
update override will
not be applied at all.
what is the difference steps for data modeling?
when u connect the repository for the first time it asks you
for user name & password of repository and database both.But
subsequent times it asks only repository password. why?
what do u do when DB time takes more?in sap bi
how do u handle performance issues in Informatica . where
can u monitor the performance ?