Explain about power designer data modeling software?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 Answers  


working of line item dimension......pls,tell overall flow

1 Answers  


Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

0 Answers  


Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

0 Answers   Cap Gemini,


What is etl process?

0 Answers  






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

0 Answers  


can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 Answers  


What are materialized views & where do we use them?

0 Answers  


what are the cubes developed in a sap bw project and what is the requirement for developing it?

0 Answers   Maersk,


what is HISTOGRAM? how to generate statistics?

1 Answers  


How etl testing is different from database testing?

0 Answers  


In Which Transformation We Can Use Having Clause In Informatica?

0 Answers  


Categories