Knowledge on what are the improtant characteristice that we
need ot consider while developing an ETL Code
No Answer is Posted For this Question
Be the First to Post Answer
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,
what happens if the info.server doesn't find the session parameter in the parameter file?
What is data cleaning?
What is partitioning? Explain different types of partitioning?
what are the different Reporting and ETL tools available in the market?
what is the difference steps for data modeling?
how do u implement unconn.stored proc. in a mapping?
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
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 table F1.
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?
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
Explain about power designer data modeling software?