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
- 7052 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
How do you load first and last records into target table?
How to create or import flat file definition in to the warehouse designer?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How can you define user defied event?
Write the different tools in the workflow manager?
What is the command used to run a batch?
What are data-driven sessions?
Performance tuning( what you did in performance tuning)
can anyone suggest best free Talend data integration training online
What is target load order?
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?
How to extract sap data using informatica?
What is rank index in rank transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What does role playing dimension mean?
