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
- 30731 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
what are the deliverables?in your project?
Why do you use Mapping Parameter and mapping variable?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to call shell scripts from informatica?
According to his methodology what all you need before you build a datawarehouse
Write the advantages of partitioning a session?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
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 are the performance considerations when working with aggregator transformation?
what is degenerated dimension?
What do you mean by enterprise data warehousing?
What are the tasks that source qualifier perform?
To import the flat file definition into the designer where should the flat file be placed?
Which transformation is needed while using the Cobol sources as source definitions?
Explain lookup transformation source types in informatica
