ETL Interview Questions
Questions Answers Views Company eMail

When you have 2 servers in two different time zone and if you need to extract data from 1 server and load it in another server, how do you go about it? Best method to be used.

3 11141

what is the main role of FI on business

1607

what are variable ports and list two situations when they can be used?

Satyam,

4 13901

what are the parts of Informatica server ?

GE,

1 5260

how does the server recongnise the source and target databases.Elaborate on this

Accenture,

2069

list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys

2 6066

what is different between sequential batch and concurrent batch and which is recommended and why?

4436

what is the use of server?

1716

what is the use of server manager?

1588

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

1806

how do u implement scheduling in Informatica?

Cognizant,

1 6618

what is the meaning of upgradation of Repository?

IBM,

3276

what is the indicator file and where it is used?

1 4044

1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?

1647

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3292


Post New ETL Questions

Un-Answered Questions { ETL }

What is tracing level and what are the types?

516


list and discuss two approaches for updation of target table in Informatica and how they are different.

1717


Can we create Hierarchies in generic datasources?

1901


What is etl process?

520


can be used COM component in Informatica ?

1597






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

1283


What are the modules in Power Mart?

508


how do u really know that paging to disk is happening while u are using a lookup transform?

1543


What are the key benefits of ETL Testing?

546


diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2070


Compare ETL & Manual development?

537


What is tracing level?

602


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

1670


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

1445


State the differences between shortcut and reusable transformation

496