teradata interview questions and answers Interview Questions and Answers

  • Informatica ETL Interview Questions and Answers

    Question.1 Can you use mapping without source qualifier? Answer:  Not possible, If source RDEMS/DBMS/Flat file use SQ or use normalizer if the source cobol feed.  Question 2.When do you use a normalizer? Answer:  Normalized can be used in Relational to denormilize data. [sociallocker] Question.3 What are stored procedure transformations. Purpose..



  • Informatica Interview Questions with answers

    Question.1 What are the different uses of a repository manager? Answer: Repository manager used to create repository which contains metadata the informatica uses to transform data to from source to target. And also it use to create informatica user’s and folders and copy, backup and restore tie repository . Question.2..



  • Datastage Interview Questions with answers

    Question.1   What is Meta Data Repository? Answer:   Meta Data is a data about the data. It also contains Query statistics ETL statistics Business subject area Source Information Target Information Source to Target mapping  Information. Question.2  What is Data Stage Engine? Answer:   It is a JAVA engine running at the background…



  • Informatica Interview questions with answers

    Question.1  What are the components of Informatica? And what is the purpose of each? Answer:   Informatica Designer, Server Manager & Repository Manager. Designer for Creating Source & Target definitions, Creating Mapplets and Mappings etc. Server Manager for creating sessions & batches, Scheduling the sessions & batches, Monitoring the trig jered..



  • Microstrategy Interview Questions and answers for Experienced

    Question.1   What is Microstrategy Desktop? Answer:   Microstrategy Desktop  is a Windows client-server software application that provides integrated monitoring, reporting, and analysis capabilities. Question.2   What does Microstrategy Desktop allow users to do? Answer:   Using Microstrategy Desktop, users can easily access and share critical corporate information they need to make cost-cutting decisions..



  • Informatica Interview Questions and answers for experienced

    Question.1  What is the difference between connected and unconnected transformation? Answer:   Connected Transformation: Connected transformation is connected to other transformations or directly to target table in the mapping. Unconnected Transformation: An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns..



  • Teradata Interview Questions and answers

    Question.1  What is the difference between FastLoad and MultiLoad? Answer:  FastLoad uses multiple sessions to quickly load large amount of data on empty table. MultiLoad is used for high-volume maintenance on tables and views. It works with non-empty tables also. Maximum 5 tables can be used in MultiLoad. Question.2  Which..



  • Informatica Interview Questions and Answers

    Question.1 What is Data warehouse? Answer: According to Bill Inmon, known as father of Data warehousing. “A Data warehouse is a subject oriented, integrated ,time variant, non volatile collection of data in support of management’s decision making process”. Question.2 What are the types of data warehouses? Answer: There are three..



  • DataStage Interview Questions and Answers

    Question.1  What is the difference between DataStage and Informatica? Answer: DataStage support parallel processing which informatica doesn’t. Links are object in the DataStage ,in Informatica it’s a port to port connectivity .In Informatica, its easy to implement Slowly Changing Dimensions which is little bit complex in Data Stage. DataStage doesn’t..