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
What are the advantages of using informatica as an etl tool over teradata?
How would you join a node to the already existing domain?
What is resilience time?
Mention some types of transformation?
have u done any performance tuning? how u ll do?
Enlist the advantages of informatica.
What are junk dimensions?
How many ways a relational source definition can be updated and what are they?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is lookup transformation?
What is Index Caches size?
What are the types of presistent cache in look up tr.
What is joiner change?
Briefly describe lookup transformation?
What is repository manager?