How to send duplicates to one target and unique rows to one
target?target is empty
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
In warehouses how many schemas are there?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain constraint based loading in informatica
On which transformations you created partitions in your project?
How do you set a varible in incremental aggregation
difference between repository database and repository service?
What is union transformation?
What are the types of data warehouses?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is enterprise data warehousing?
What is data caches/ index caches?
What is standalone command task?
Define Pmrep command?
permutations of mapplet
What is Data Caches size?