Answer / purva

System Testing : This is the iterative process. The focus
is to to get the correct answer or effective answer.This is
done after the Unit test is carried out.
Some cross module errors could also be resolved at this
stage. Post analysis the necessary corrections to the
components are made and finaaly the modules are successfull
system tested when the errors are non-existent or
negligible.

Integration Testing : This is the final stage as all the
errors are removed almost and is at the final stage, so
here we concentrate on integrateing the results across
modules. performance of the etl is tested.
Any new answers are pls provide

Answer / gagan

We can use expression transformation and in expression
transformation we can compare previous records and current
records and if previous record matches the current record
then we can keep a value as 'Reject' for a variable port
and otherwise null.
After that by applying filter tansformation we can remove
all records which have column value as 'Reject'

This will remove duplicate values.

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,

---

I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,

---

How to delete duplicate records in a flat file source?

2 Answers  

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

What is the different lookup cache(s)?

0 Answers  

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

---

What is source qualifier?

6 Answers   SDS,

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---