TECHLOGBOOKS

Monday, 7 August 2017

EDQ Interview Questions & Answers-1

  1. What are the types of external souces from which you can import data into EDQ?
EDQ can import from different types of sources like text(.txt, .dsv etc), excel (.xls, csv), and all types of databases like Oracle, DB2, Postgresql, Mysql, Microsoft Sql Server, Sybase etc..

  1. What are the objects you create in EDQ to import files or from database?
First of all we need to create a Data store pointing to file or database and then create and run the staged data to import data. In case of file you can either give the local path or if its server give the server credentials and path of the file to select the file.

  1. What is the Staged data?
Staged data is where you store the intermediate or final results within your EDQ space, it’s like a EDQ table which stores the Processed data from the processes

  1. What is the different between Staged data and Reference data?
Staged data is used to store the data being processed or the final data after processing and considered as working data.
Reference data is something which you refer with some values in the working data and get the other corresponding values from the reference data in a same record.
Ex: Suppose you have country in your working data as “United States of America” and for the country code, you look up in the Reference data with Country name and get country code, where you have already stored all country and corresponding codes.

  1. Name some of the commonly used processor
    1. Reader
    2. Writer
    3. Lookup and Return
    4. Logic Check
    5. Duplicate check
    6. Group and Merge
    7. Merge etc

No comments:

Post a Comment