can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1299

How we drill up week to month?

609

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

2981

How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1549

Give some examples where proc report’s defaults are different than proc print’s defaults?

582

What are the functionalities of link collector?

617

What is a grid in Informatica?

601

How to load a Dimension ? and how to load a fact table?

943

What are the features of ab initio?

623

Where can we find the throughput option in informatica?

594

Highlight a few of the advantages that ETL tools have over Teradata.

605

What are cognos connection initial page components?

593

How many project sources we can create in metadata?

550

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1524

Describe the ways in which you can create macro variables? : sas-macro

567