-
ETL Testing in Informatica
As an ETL tester what are the things to test in Informatica tool. What are the types of testing has to do in informatica and the things to test in each type? If there is any documents on ETL testing
-
-
Test objective is to.
1.To find faults in software
2.To purify that software has no defects.
3.To find perform problems.
4.To give cunt in software.
select best option.
-
-
-
Cache Files
What are the T/Rs which create cache files?
-
-
ETL developer Responsibilities
what are the roles and responsibilities of an ETL developer/designer/team lead?
-
-
Record mismatch
while moving data from source to target
in source there 1000 records and in target there 990 records
how would u find that mismatch occured in particular column -
-
PRIMARY KEY NULL CHECK
Primary key should not allow null values.But still we are checking primary key null check in ETL Testing.Why?
-
How to write an query for the following?
Say in a source there are 1 lakh records and in Target there are 1 lakh records. Some records in a column having the mismatch value (.ie., Instead of displaying 1000 in a column, it is displaying as 100 in Target column) The source file is from an DB2 and, Oracle (different source) and, Target is an SQL server. So how to find it by a simple way?
-
What are active transformation / Passive transformations?
Answered by kiran on 2005-05-08 09:32:14: An active transformation can change the number of rows as output after a transformation, while a passive transformation does not change the number of rows and passes through the same number of rows that was given to it as input.
-
Banking, Healthcare ETL Process Critical Issues
What kind of Issues/bugs arise in ETL projects? I would like to know few issues (critical to somewhat bugs ) normally occur in ETL process especially when testing? Domains can be banking, healthcare or any.
-
Sql server scenario
How to get the below output for following table ? can you please clarify this
--------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------
--------------------------
100 | null | null | null
-------------------------- -
Assignment Task
Why we use assignment task in Informatica and what happens after we used it?
-
Testing Source and Target in Different Database
How will you test if your source system and target system in different database.
-
ETL Case and Decode
What is the difference between case and decode?
-
ETL Row number, Rank and Dense Rank
What is row number, rank and dense rank? What are its uses?
ETL Interview Questions
Ans