Interested to Buy Any Domain ? << Click Here >> for more details...
there is a product table
prodid prodname price
100 cinthol 10
101 hamam 10
102 neem 20
103 cake 30
in the above table the price of some products are
duplicated and some product prices are distinct we want to
push the duplicated prices to one target and non-duplicated
prices to other target without using expression and
sequence generator transformation
- 4 Answers
- 6943 Views
- I also Faced
- E-Mail Answers
Answer Posted / babu
Hi,
If your source is RDBMS,u can writ sql override in
sourequalifier.
select p.*,pc.cno from product p,(select price,count(price)
cno from product group by price) pc where pc.price=p.price;
In RTR group1 cno=1
group2 cno>1
OR
If source is flatfile
SRC-->SQ-->AGG(GROUP BY PRICE,CNO=COUNT(PRICE))
|
SRC-->SQ-->JNR--RTR (GRP1 CNO=1 )-->TRG1
(GRP2 CNO>1 )-->TRG2
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
can any one give some examples for pre sql and post sql(Except dropping and creating index).
State the differences between sql override and lookup override?
Why update strategy and union transformations are active?
How many input parameters can exist in an unconnected lookup?
How can you differentiate between powercenter and power map?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How to generate sequence numbers?
differences between service based and product based?
Reusable transformation and shortcut differences
What are the restrictions of union transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
While migrating the data from one environment to another environment how would you manage the connections?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is the cumulative sum and moving sum?
What are the guidelines to be followed while using union transformation?
