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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / akash
Hi Krish,
In this case we will get distinct records in one table and
one record each for duplicate records of each table.
For ex:
Source:
101 neem
101 neem
101 neem
Duplicate target:
101 neem
Can you suggest any way through which we can get as many
duplicate records as there are in the source?
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krish
take AGG t/r and give count on price
and in router count(price)=1 and count(price)>1.
Is This Answer Correct ? | 0 Yes | 2 No |
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Why filter transformation is an active one?
plz plz plz send client names and project names in informatica?
How can yoU improve session performance in aggregator transformation?
What is target designer and target load order?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
why normalizer transformation can not used in mapplet? plzzzz answer
hi all, Can anyone please tell me the relationship between informatica and business objects
What is a configuration management?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
what is curr val use for in sequence generator?