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
- 30997 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
wat are deployement groups in informatica, how it will be used for developers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can we create index after completion of load process?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What do you mean by worklet?
How an expression transformation differs from aggregator transformation?
What does command task mean?
explain about unit testing? in real time?
On which transformations you created partitions in your project?
Explain constraint based loading in informatica
without table how to come first record only in oracle?
what is song in infrmatica...?
Why update strategy and union transformations are active?
how to load dimension table and fact table. plz tell me the steps.
What is fact table? Explain the different kinds of facts.
