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 tasks that can be performed using sq?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is joiner transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Explain your project of banking domian.
what is diff b/t sorter t/r and agg have the option sorter property...
What is the reusable transformation?
What is difference between a gateway node and worker node?
How are indexes created after completing the load process?
What is the status code in stored procedure transformation?
What is mapping debugger?
How would you join a node to the already existing domain?
What is xml source qualifier transformation in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?