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
- 31005 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / shiva
s-->sq-->agg-->rtr-->tgt1
'--> tgt2
in aggr take two ports count(*)=1
count(*)>1 take group by on column
send this to rtr(create 2 groups in rtr)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are pre and post-session shell commands?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
draw informatica architecture 8.6 ?
Is there any way to read the ms excel datas directly into informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is meant by pre and post session shell command?
Did u used latest transformations of 8.6.0? for what?
Explain what are the different versions of informatica?
What is union transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Can u generate reports in Informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to convert multiple rows to single row (multiple columns) in informatica
