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

Answers were Sorted based on User's Feedback



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

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

Is This Answer Correct ?    6 Yes 0 No

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

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  


Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,


performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,


scd methodology?

2 Answers  


Why we require dwh in particular projects?

1 Answers   Amdocs,






What are Business Components in Informatica?

1 Answers  


How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  


Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,


hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  


 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,


Define update strategy?

0 Answers  


There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,


Categories