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
- 30951 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 the differences between oltp and olap?
How to elaborate tracing level?
How is union transformation utilized?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is standalone command task?
What all are steps in up gradation of Informatica server?
Mention a few design and development best practices for informatica?
Target increases every day even though no new record was inserted
can we override a native sql query within informatica? How do we do it?
Could you explain what is enterprise data warehouse?
What is the need of etl tools?
what is the -ve test case in your project.
What are the different lookup cache(s)?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
State the limitations where we cannot use joiner in the mapping pipeline?
