Hi,tell me the system testing and Integration Testing in
the Informatica ? Thank You
Answer Posted / 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 View All Answers
Explain joiner transformation in informatica
What are the different types of repositories created using informatica?
How do you use reject loader.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is the difference between router and filter?
Global and Local shortcuts. Advantages.
What is a passive transformation?
Different sorts of metadata that stores in the storage facility?
What is a joiner transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Define sessions in informatica etl?
How can we use batches?
Explain the aggregator transformation?
Why union transformation is an active transformation?
State the differences between sql override and lookup override?