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
- 6939 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to load data in informatica ?
Is there any way to read the ms excel datas directly into informatica?
What is domain in terms of informatica?
What is a sequence generator transformation?
What happens when a session fails and you click on recover?
What the difference is between a database, a data warehouse and a data mart?
How can you define user defied event?
What are the mapping parameters and mapping variables?
What is different between the data warehouse and data mart?
What is a surrogate key?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is the benefit of partitioning a session?
