ETL Interview Questions
Questions Answers Views Company eMail

How many types of transformations supported by sorted input?

877

How to fine tune mappings?

712

What is a mapping, session, worklet, workflow, mapplet?

674

What is etl process?

681

What is tracing level? How many types of transformations supported by sorted input?

728

Explain what are the various etl tools in the market?

696

Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

685

Explain do we need an etl tool? When do we go for the tools in the market?

785

Explain do we need an etl tool?

689

When do we go for the tools in the market?

710

Explain what is etl process? How many steps etl contains explain with example?

658

How many steps etl contains explain with example?

649

Explain and compare etl & manual development?

673

Explain the difference between etl tool and olap tools?

678

What are various etl tools in the market?

701


Post New ETL Questions

Un-Answered Questions { ETL }

can be used COM component in Informatica ?

1796


How many steps etl contains explain with example?

649


What are the ETL Testing Operations?

791


what are the concerns of OLTP and DSS systems?

1708


how do u implement configuration management in Informatica?

4539






Which transformation we use to convert 'NA' to 'Not Available'

1019


what is pmrep command?

2117


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

1517


how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2402


Can we create Hierarchies in generic datasources?

2089


What is grain of fact?

695


Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

1736


Can u access a repository created in previous version of Informatica?

1623


How to increase performance without changing anything in mapping.( In prod)

941


dimension object created in oracle can be imported in designer?how?

2647