Teradata Interview Questions

 

  1. 1. What Is Basic Teradata Query Language?

    Answer :

    1. It allows us to write SQL statements along with BTEQ commands. We can use BTEQ for importing, exporting and reporting purposes.
    2. The commands start with a (.) dot and can be terminated by using (;), it is not mandatory to use (;).
    3. BTEQ will assume any thing written with out a dot as a SQL statement and requires a (;) to terminate it. know more at Teradata online training

  2. Question 2. 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.

  3.  3. Which Is Faster Fastload Or Multiload?

  4. FastLoad.

  5. 4. Difference Between Inner Join And Outer Join?

    Answer :

    An inner join gets data from both tables where the specified data exists in both tables. An outer join gets data from the source table at all times, and returns data from the outer joined table ONLY if it matches the criteria.

  6. Question 5. What Is Multi Insert?

    Answer :

    Inserting data records into the table using multiple insert statements. Putting a semi colon in front of the key word INSERT in the next statement rather than terminating the first statement with a semi colon achieves it. know more at Teradata training

  7.  6. Is Multi Insert Ansi Standard?

    Answer :

    No.

    1. Question 7. How Do You Create A Table With An Existing Structure Of Another Table With Data And With No Data?

      Answer :

      Create table Customerdummy as Customer with data / with no data;

      1. Question 8. What Is The Opening Step In Basic Teradata Query Script?

        Answer :

        .Logon tdipid/username, password.

        1. Question 9. Can You Fastexport A Field, Which Is Primary Key By Putting Equality On That Key?

          Answer :

          No.

          1. Question 10. Did You Write Stored Procedures In Teradata?

            Answer :

            No, because they become a single amp operation and my company didn’t encourage that.

          2. 11. What Is The Use Of Having Index's On Table?

            Answer :

            For faster record search.

            1. Question 12. Is It Necessary To Add? Quit Statement After A Bteq Query When I Am Calling It In A Unix Environment?

              Answer :

              Not necessary but it is good to add a QUIT statement after a query.

            2. 13. There Is A Column With Date In It. If I Want To Get Just Month How It Can Be Done? Can I Use Sub String?

              Answer :

              Sub string is used with char fields. So it cannot be used. To extract month from a date column, ex select extract (month from <column name>). Same thing for year or day. Or hour or minutes if it’s a time stamp (select extract (minute from column name). know more at Teradata online training from India

            3.  14. What's The Syntax Of Sub String?

              Answer :

              SUBSTRING (string_expression, n1 [n2]).

            4.  15. While Creating Table My Dba Has Fallback Or No Fallback In His Ddl. What Is That?

              Answer :

              FALLBACK requests that a second copy of each row inserted into a table be stored on another AMP in the same cluster. This is done when AMP goes down or disk fails.

              1. Question 16. My Table Got Locked During Mload Due To A Failed Job. What Do I Do To Perform Other Operations On It?

                Answer :

                Using RELEASE MLOAD. It removes access locks from the target tables in Teradata. It must be entered from BTEQ and not from MultiLoad. To proceed, you can do RELEASE MLOAD <table name>.

              2. 17. How To Find Duplicates In A Table?

                Answer :

                Group by those fields and select id, count(*) from table group by id having count (*) > 1.

              3. 18. How Do You Verify A Complicated Sql?

                Answer :

                I use explain statement to check if the query is doing what I wanted it to do.

                1. Question 19. How Many Tables Can You Join In V2r5?

                  Answer :

                  Up to 64 tables.

                2. Question 20. How Do You See A Ddl For An Existing Table?

                  Answer :

                  By using show table command. know more at Teradata online course

Comments

Post a Comment

Popular posts from this blog

What is Tableau?

Image
  What is Tableau? Tableau  is a powerful and fastest growing data visualization tool used in the Business Intelligence Industry. It helps in simplifying raw data in a very easily understandable format. Tableau helps create the data that can be understood by professionals at any level in an organization. It also allows non-technical users to create customized dashboards. know more at Tableau online training Data analysis is very fast with Tableau tool and the visualizations created are in the form of dashboards and worksheets. The best features of Tableau software are Data Blending Real time analysis Collaboration of data The great thing about Tableau software is that it doesn’t require any technical or any kind of programming skills to operate. The tool has garnered interest among the people from all sectors such as business, researchers, different industries, etc. Tableau Product Suite The Tableau Product Suite consists of Tableau Desktop Tableau Public Tableau Online Tableau Server
Read more

SharePoint Interview Questions

  1) What is MS Share-Point is used for? MS Share Point is used for multiple purposes, and it acts as a back-end system that combines all your employees PC’s and mobile device together allowing them to communicate symmetrically. know more at Share point online training Share documents:  It allows to store and share documents by anyone in the company also it allows to work on a single document by several employees at same time Intranet:  Dashboards can be customized by department and access to all employees are given to check the regular updates into the company Extranet:  With the help of SharePoint, you can provide an outside company a space or a site to upload all the information your company may require from them Websites:  You can use SharePoint to manage and build a publicly facing site as well.  display relationship between different inputs through charts and graphs Collaboration:  Through SharePoint employees can be interlinked with each other and co-ordinate their efforts on on
Read more

Testing Interview Questions

  1. What do you understand by software testing? Software testing is a validation process which confirms that a system works as per the business requirements. It qualifies a system on various aspects such as usability, accuracy, completeness, efficiency, etc. ANSI/IEEE 1059 is the global standard that defines the basic principles of testing. 2. When should you stop the testing process? The testing activity ends when the testing team completes the following milestones. Test case execution The successful completion of a full test cycle after the final bug fix marks the end of the testing phase. know more at Testing tool online training Testing deadline The end date of the validation stage also declares the closure of the validation if no critical or high-priority defects remain in the system. Code Coverage(CC) ratio It is the amount of code  concealed  via automated tests. If the team achieves the intended level of code coverage (CC) ratio, then it can choose to end the validation. Mean
Read more