5. Consider the following products data which contain duplicate rows.
A
B
C
C
B
D
B
Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table.
The first table should contain the following output
A
D
The second target should contain the following output
B
B
B
C
C
- 1 Answers
- 1998 Views
- I also Faced
- E-Mail Answers
Answer / Vishal Kumar Jha
To create a mapping that loads unique products in one table and duplicates in another, you can follow these steps using PowerCenter (Informatica):
1. Create two new Relationships:
- Relationship 1: Connect the source to the target 'Unique Products' table with a filter that selects only distinct product rows.
- Relationship 2: Connect the source to the target 'Duplicate Rows' table with a filter that selects duplicate product rows.
2. In each relationship, configure the transformation settings as follows:
- Unique Products (Relationship 1):
- Source qualifier: Select all columns from the source table.
- Target qualifier: Create a new table called 'Unique_Products' with columns A and D only.
- Duplicate Rows (Relationship 2):
- Source qualifier: Select all columns from the source table.
- Target qualifier: Create a new table called 'Duplicate_Rows' with columns B, C, and C (repeated).
| Is This Answer Correct ? | 0 Yes | 0 No |
how can i invoke pmcmd in command line prompt
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
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
Explain the different lookup methods used in informatica?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
what is scd?
Howmany ways yoU can update a relational source defintion and what are they?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
What is a poling?
Teradata 
