If you are looking for a job in Automation Testing combined with ETL (Extract ,Transform and Loading) Testing Automation Testing using UFT/Selenium then this is the right platform. ETL stands for Extract-Transform-Load and it is a process of how data is loaded from the source system to the data warehouse. Data is extracted from an OLTP database, transformed to match the data warehouse schema and loaded into the data warehouse database. There are many jobs on ETL testing some of the most popular jobs in it are software engineer, QA analyst, ETL test engineer, quality analyst, manual tester, ETL developer, data engineer, data consultant, python developer, data lead, ETL architect, integration engineer, big data developer and analyst etc. please have a look at our ETL testing jobs interview questions and answers page to shortlist in your interview.
ETL stands for extraction, transformation and loading.
ETL provide developers with an interface for designing source-to-target mappings, transformation and job control parameter.
Take data from an external source and move it to the warehouse pre-processor database.
Transform data task allows point-to-point generating, modifying and transforming data.
Load data task adds records to a database table in a warehouse.
Question 2. What Is The Difference Between Etl Tool And Olap Tools?
ETL tool is meant for extraction data from the legacy systems and load into specified database with some process of cleansing data.
ex: Informatica, data stage ....etc
OLAP is meant for Reporting purpose in OLAP data available in Multidirectional model. so that you can write simple query to extract data from the data base.
ex: Business objects, Cognos....etc
Question 3. Can We Lookup A Table From Source Qualifier Transformation. Ie. Unconnected Lookup?
You cannot lookup from a source qualifier directly. However, you can override the SQL in the source qualifier to join with the lookup table to perform the lookup.
Question 4. What Is Ods (operation Data Source)?
Question 5. Where Do We Use Connected And Unconnected Lookups?
Question 6. Where Do We Use Semi And Non Additive Facts?
Additive: A measure can participate arithmetic calculations using all or any dimensions.
Ex: Sales profit
Semi additive: A measure can participate arithmetic calculations using some dimensions.
Ex: Sales amount
Non Additive:A measure can't participate arithmetic calculations using dimensions.
Question 7. What Are Non-additive Facts In Detail?
Question 8. What Is A Staging Area? Do We Need It? What Is The Purpose Of A Staging Area?
Data staging is actually a collection of processes used to prepare source system data for loading a data warehouse. Staging includes the following steps:
Question 9. What Is Latest Version Of Power Center / Power Mart?
The Latest Version is 7.2
Question 10. What Are The Modules In Power Mart?
Question 11. What Are Active Transformation / Passive Transformations?
Question 12. What Are The Different Lookup Methods Used In Informatica?
Connected lookup will receive input from the pipeline and sends output to the pipeline and can return any number of values it does not contain return port.
Unconnected lookup can return only one column it contain return port.
Question 13. Can Informatica Load Heterogeneous Targets From Heterogeneous Sources?
Question 14. How Do We Call Shell Scripts From Informatica?
Specify the Full path of the Shell script the "Post session properties of session/workflow".
Question 15. What Is Informatica Metadata And Where Is It Stored?
Informatica Metadata is data about data which stores in Informatica repositories.
Question 16. What Is A Mapping, Session, Worklet, Workflow, Mapplet?
Question 17. What Are Parameter Files? Where Do We Use Them?
Parameter file defines the value for parameter and variable used in a workflow, worklet or session.
Question 18. Can We Override A Native Sql Query Within Informatica? Where Do We Do It? How Do We Do It?
Yes, we can override a native sql query in source qualifier and lookup transformation.
In lookup transformation we can find "Sql override" in lookup properties. By using this option we can do this.
Question 19. Can We Use Procedural Logic Inside Infromatica? If Yes How , If No How Can We Use External Procedural Logic In Informatica?
Yes, you can use advanced external transformation, You can use c++ language on unix and c++, vb vc++ on windows server.
Question 20. Do We Need An Etl Tool? When Do We Go For The Tools In The Market?
It is used to Extract(E) data from multiple source systems(like RDBMS, Flat files, Mainframes, SAP, XML etc) transform(T) then based on Business requirements and Load(L) in target locations.(like tables, files etc).
Need of ETL Tool:
An ETL tool is typically required when data scattered across different systems.(like RDBMS, Flat files, Mainframes, SAP, XML etc).
Question 21. How To Determine What Records To Extract?
When addressing a table some dimension key must reflect the need for a record to get extracted. Mostly it will be from time dimension (e.g. date >= 1st of current month) or a transaction flag (e.g. Order Invoiced Stat). Foolproof would be adding an archive flag to record which gets reset when record changes.
Question 22. What Is Full Load & Incremental Or Refresh Load?
Full Load: completely erasing the contents of one or more tables and reloading with fresh data.
Incremental Load: applying ongoing changes to one or more tables based on a predefined schedule.
Question 23. When Do We Analyze The Tables? How Do We Do It?
The ANALYZE statement allows you to validate and compute statistics for an index, table, or cluster. These statistics are used by the cost-based optimizer when it calculates the most efficient plan for retrieval. In addition to its role in statement optimization, ANALYZE also helps in validating object structures and in managing space in your system. You can choose the following operations: COMPUTER, ESTIMATE, and DELETE. Early version of Oracle7 produced unpredictable results when the ESTIMATE operation was used. It is best to compute your statistics.
sum(decode(nvl(NUM_ROWS,9999), 9999,0,1)) analyzed,
sum(decode(nvl(NUM_ROWS,9999), 9999,1,0)) not_analyzed,
where OWNER not in ('SYS', 'SYSTEM')
group by OWNER
Question 24. Compare Etl & Manual Development?
These are some differences b/w manual and ETL development.
Question 25. What Is Real Time Data-wearhousing?
Question 26. Explain The Use Lookup Tables And Aggregate Tables?
Question 27. Define Slowly Changing Dimensions (scd)?
SCD are dimensions whose data changes very slowly.
eg: city or an employee.
Question 28. What Is Cube Grouping?
A transformer built set of similar cubes is known as cube grouping. They are generally used in creating smaller cubes that are based on the data in the level of dimension.
Question 29. What Is Data Wearhousing?
Question 30. What Is Virtual Data Wearhousing?
A virtual data warehouse provides a collective view of the completed data. It can be considered as a logical data model of the containing metadata.
Question 31. What Is Active Data Wearhousing?
An active data warehouse represents a single state of the business. It considers the analytic perspectives of customers and suppliers. It helps to deliver the updated data through reports.
Question 32. What Is Data Modeling And Data Mining?
Data Modeling is a technique used to define and analyze the requirements of data that supports organization’s business process. In simple terms, it is used for the analysis of data objects in order to identify the relationships among these data objects in any business.
Data Mining is a technique used to analyze datasets to derive useful insights/information. It is mainly used in retail, consumer goods, telecommunication and financial organizations that have a strong consumer orientation in order to determine the impact on sales, customer satisfaction and profitability.
Question 33. What Are Critical Success Factors?
Key areas of activity in which favorable results are necessary for a company to obtain its goal.
There are four basic types of CSFs which are:
Question 34. What Is Data Cube Technology Used For?
Data cubes are commonly used for easy interpretation of data. It is used to represent data along with dimensions as some measures of business needs. Each dimension of the cube represents some attribute of the database. E.g profit per day, month or year.
Question 35. What Is Data Cleaning?
Question 36. Explain How To Mine An Olap Cube?
An extension of data mining can be used for slicing the data the source cube in discovered data mining.
The case table is dimensioned at the time of mining a cube.
Question 37. What Are Different Stages Of Data Mining?
A stage of data mining is a logical process for searching large amount information for finding important data.
Stage 1: Exploration: One will want to explore and prepare data. The goal of the exploration stage is to find important variables and determine their nature.
Stage 2: pattern identification: Searching for patterns and choosing the one which allows making best prediction, is the primary action in this stage.
Stage 3: Deployment stage: Until consistent pattern is found in stage 2, which is highly predictive, this stage cannot be reached. The pattern found in stage 2, can be applied for the purpose to see whether the desired outcome is achieved or not.
Question 38. What Are The Different Problems That Data Mining Can Slove?
Data mining can be used in a variety of fields/industries like marketing of products and services, AI, government intelligence.
The US FBI uses data mining for screening security and intelligence for identifying illegal and incriminating e-information distributed over internet.
Question 39. What Is Data Purging?
Deleting data from data warehouse is known as data purging. Usually junk data like rows with null values or spaces are cleaned up.
Data purging is the process of cleaning this kind of junk values.
Question 40. What Is Bus Schema?
A BUS schema is to identify the common dimensions across business processes, like identifying conforming dimensions. It has conformed dimension and standardized definition of facts.
Question 41. Define Non-additive Facts?
Non additive facts are facts that cannot be summed up for any dimensions present in fact table. These columns cannot be added for producing any results.
Question 42. What Is Conformed Fact? What Are Conformed Dimensions Used For?
Conformed fact in a warehouse allows itself to have same name in separate tables. They can be compared and combined mathematically. Conformed dimensions can be used across multiple data marts. They have a static structure. Any dimension table that is used by multiple fact tables can be conformed dimensions.
Question 43. What Is A Three Tier Data Warehouse?
A data warehouse can be thought of as a three-tier system in which a middle system provides usable data in a secure way to end users. On either side of this middle system are the end users and the back-end data stores.
Question 44. What Is The Metadata Extension?
Question 45. How Can We Use Mapping Variables In Informatica? Where Do We Use Them?
Yes. we can use mapping variable in Informatica.
The Informatica server saves the value of mapping variable to the repository at the end of session run and uses that value next time we run the session.
Question 46. What Is Etl Process ?how Many Steps Etl Contains Explain With Example?
ETL is extraction, transforming, loading process, you will extract data from the source and apply the business role on it then you will load it in the target the steps are :
Question 47. Give Some Popular Tools?
Question 48. Give Some Etl Tool Functionalities?
While the selection of a database and a hardware platform is a must, the selection of an ETL tool is highly recommended, but it's not a must. When you evaluate ETL tools, it pays to look for the following characteristics:
Question 49. How Can I Edit The Xml Target, Are There Anyways Apart From The Editing The Xsd File. Can I Directly Edit The Xml Directly In Informatica Designer?
No you cannot edit it from Informatica designer. But still you can change the precession of the ports if xml source is imported from DTD file.
Question 50. What Is The Difference Between Informatica 7.0&8.0?
The only difference b/w informatica 7 & 8 is... 8 is a SOA (Service Oriented Architecture) whereas 7 is not. SOA in informatica is handled through different grid designed in server.
Question 51. Where Do We Use Connected And Un Connected Lookups?
If return port only one then we can go for unconnected. More than one return port is not possible with Unconnected. If more than one return port then go for Connected.
Question 52. What Are The Various Tools? - Name A Few.
Question 53. What Are The Various Test Procedures Used To Check Whether The Data Is Loaded In The Backend, Performance Of The Mapping, And Quality Of The Data Loaded In Informatica?
The best procedure to take a help of debugger where we monitor each and every process of mappings and how data is loading based on conditions breaks.
Question 54. What Is The Difference Between Joiner And Lookup?
joiner is used to join two or more tables to retrieve data from tables(just like joins in sql).
Look up is used to check and compare source table and target table .(just like correlated sub-query in sql).
Question 55. If A Flat File Contains 1000 Records How Can I Get First And Last Records Only?
By using Aggregator transformation with first and last functions we can get first and last record.
Question 56. How Do You Calculate Fact Table Granularity?
Granularity, is the level of detail in which the fact table is describing, for example if we are making time analysis so the granularity maybe day based - month based or year based.
Question 57. What Are The Different Versions Of Informatica?
Here are some popular versions of Informatica.
Question 58. Techniques Of Error Handling - Ignore , Rejecting Bad Records To A Flat File , Loading The Records And Reviewing Them (default Values)?
Rejection of records either at the database due to constraint key violation or the informatica server when writing data into target table. These rejected records we can find in the bad files folder where a reject file will be created for a session. We can check why a record has been rejected. And this bad file contains first column a row indicator and second column a column indicator.
These row indicators are of four types:
T- Truncated data,
And depending on these indicators we can changes to load data successfully to target.
Question 59. What Is The Difference Between Power Center & Power Mart?
PowerCenter - ability to organize repositories into a data mart domain and share metadata across repositories.
PowerMart - only local repository can be created.
Question 60. What Are Snapshots? What Are Materialized Views & Where Do We Use Them? What Is A Materialized View Log?
Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table. Snapshots are mirror or replicas of tables.
Views are built using the columns from one or more tables. The Single Table View can be updated but the view with multi table cannot be updated.
A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.
A pre-computed table comprising aggregated or joined data from fact and possibly dimension tables. Also known as a summary or aggregate table.
ETL Testing Related Tutorials
|Data Warehouse ETL Toolkit Tutorial||Database Testing Tutorial|
ETL Testing Related Interview Questions
|Data Warehouse ETL Toolkit Interview Questions||Manual Testing Interview Questions|
|SQL Interview Questions||Share Point Administration Interview Questions|
|Database Testing Interview Questions||Automation Testing Interview Questions|
|Rational Functional Tester Interview Questions||Embedded Testing Interview Questions|
|Unix/Linux Interview Questions||Radar Test Engineer Interview Questions|
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.