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
- 6951 Views
- I also Faced
- E-Mail Answers
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 |
what are the types of Data warehousing ?
What is meant by target load plan?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
What is the difference between view and materialised view?
In operator is used in which transformation in informatica 8.6.0
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
have you developed documents in your project? and what documents we develop in realtime?
What is the Difference between DSS & OLTP?
Can informatica load heterogeneous targets from heterogeneous sources?
What is difference between stored procedure transformation and external procedure transformation?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
Teradata 
