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
what are Lookup caches options? Including persistent caches.
how do u implement unconn.stored proc. in a mapping?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
hoe to access second value in mapping parameter if it is having more than one value ?????????????
Can there be sub steps of etl steps?
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 purpose?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
if u can't find what you are looking for in lookup table, how do you handle?
how does the server recongnise the source and target databases.Elaborate on this
Can u access a repository created in previous version of Informatica?
What is a mapping, session, worklet, workflow, mapplet?
what is the indicator file and where it is used?