Hi,tell me the system testing and Integration Testing in
the Informatica ? Thank You
Answers were Sorted based on User's Feedback
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 |
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 |
Explain scd type 3 through mapping.
Does Facttable Normalized or Denormalized?
What are the settings that you use to configure the joiner transformation?
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
How to generate the HTML output using Informatica.
explain different levels in pushdown optimization with example?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
can we use bulk loading when we use look in mapping
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
What is power center repository?
What will be the approach?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM