ETL Interview Questions
Questions Answers Views Company eMail

SCD2 will work on only dimension tables as well as fact Table?

Infosys,

981

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

852

What is granularity? Please explain with example

IBM,

1 1324

Explain me ETL project architecture in Detail?

Infosys,

1924

In Which Transformation We Can Use Having Clause In Informatica?

823

Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

IBM, Saama Tech, Wipro,

1 1101

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

IBM, Saama Tech, Wipro,

782

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

IBM, Saama Tech, Wipro,

786

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

833

What are the different ways to deploy the code in informatica?

IBM, Saama Tech, Wipro,

1 1603

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

Accenture, Saama Tech, TCS,

2 2667

What is data modeling and data mining?

554

What are the ETL Testing Operations?

617

Explain the use lookup tables and Aggregate tables?

549

What is data cleaning?

549


Post New ETL Questions

Un-Answered Questions { ETL }

hoe to access second value in mapping parameter if it is having more than one value ?????????????

1130


Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1373


What do you understand by active and passive transformations?

550


How etl testing is different from database testing?

519


Explain what are the various etl tools in the market?

517






what is the difference steps for data modeling?

2078


Explain about enterprise scalability and roi of data integration suite?

490


What are three tier systems in etl?

619


Explain the key challenges that you face while performing etl testing.

571


What do you understand by the term ‘transformation’?

524


What is cube grouping?

559


how do u set partition points in the mapping?

1797


what are the reporting tools and difference between them?

1589


What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

551


what are the concerns of OLTP and DSS systems?

1969