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
- 6932 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
Where do we use mapping variables in informatica?
How to extract the informatica rejected data?
What is the cumulative sum and moving sum?
scenario where i can use only concurrent execution of workflow.
What is different between the data warehouse and data mart?
Explain lookup transformation source types in informatica
what is index?how it can work in informatica
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 do you understand by term role-playing dimension?
Which transformation is needed while using the Cobol sources as source definitions?
Clarify the utilization of aggregator cache record?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What the difference is between a database, a data warehouse and a data mart?
What can we do to improve the performance of informatica aggregator transformation?
Enlist the differences between database and data warehouse.
