Interested to Buy Any Domain ? << Click Here >> for more details...
How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 30601 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohan
SQ-->Sorter-->Expression-->Router-->TGT
Sorter: Sort by key column(EMP_ID)
Expression:
V_OLD_EMPNO EMP_ID
V_Match IIF(EMPNO=V_OLD_EMPNO,1,0)
O_EMPNO V_MATCH
Router:
create two groups under groups tab,
Original : O_EMPNO=0
Duplicates: o_EMPNO=1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Repository user profiles
What is resilience time?
How to update or delete the rows in a target, which do not have key fields?
What is standalone command task?
To import the flat file definition into the designer where should the flat file be placed?
What are the differences between oltp and olap?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
write a query to retrieve the latest records from the table sorted by version(scd)
Enlist some properties of sessions.
What are the modules in Power Center
What is the need for an etl tool?
What is informatica metadata and where is it stored?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
How can you differentiate between powercenter and power map?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
