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
No Answer is Posted For this Question
Be the First to Post Answer
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
When do we analyze the tables?
What is tracing level and what are the types?
how do u really know that paging to disk is happening while u are using a lookup transform?
flat filevalidation in informatica
how do u handle performance issues in Informatica . where can u monitor the performance ?
What is full load & incremental or refresh load?
What is a mapping, session, worklet, workflow, mapplet?
What is virtual Data Warehousing?
what is the indicator file and where it is used?
What is fact? What are the types of facts?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?