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.

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

---

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

---

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

---

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  

---

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

Difference Between ETL & ELT?

1 Answers   TCS,

---

what is constraint based load order

2 Answers   Cap Gemini,

---

what is session parameters?

1 Answers   Cap Gemini,

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  

---