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
How many steps etl contains explain with example?
what is HISTOGRAM? how to generate statistics?
What are dimensions?
CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"
explain the methodology of Data Warehousing?(Polaries)
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.
what are the session parameters? How do u set them?
What is the difference between Data Warehousing and Data Mining?
how do u set partition points in the mapping?
When do we analyze the tables?
what is different between sequential batch and concurrent batch and which is recommended and why?
explain the methodology of Data Warehousing?(Polaries)