How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 28105 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kesava reddy
Using Source Qualifier Trnsformation ,
Explantion:
1.Take 2 Source Qualifier Transformations,and
2.One sq ports connect to Target(Unique Target) then Write
a SQL Query (sqlOverride) ,
SELECT DISTINCT EMPNO,ENAME
FROM EMP;
3.TAKE ANOTHER SQ AND CONNECT TO ALL PORTS TO TARGET,THEN
DEVELOP THE SQLOVERRIDE,
SELECT * FROM EMP WHERE ROWID IN(SELECT ROWID FROM EMP
MINUS
SELECT MAX(ROWID) FROM EMP
GROUP BY EMPNO,ENAME)
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Tell me about MD5 functions in informatica
How can we handle two sessions in informatica?
How can you define user defied event?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Plz can any one say me how to get the informatica certification materials and dumps
Define enterprise data warehousing?
What are junk dimensions?
What do you understand by term role-playing dimension?
Explain why we use partitioning the session in informatica?
what are the deliverables?in your project?
What is blocking transformation?
can anyone suggest best free Talend data integration training online
How to Create a folder using pmrep command?
What is an expression transformation?
