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
- 6227 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
Explain dynamic target flat file name generation in informatica
Explain lookup transformation in informatica
Write the unconnected lookup syntax?
what is diff b/t sorter t/r and agg have the option sorter property...
What is joiner transformation in informatica?
how we can load rejected record's at run time?(not through bad files)
What do you understand by SOA of Informatica?
What is data transformation manager process?
Where is metadata stored?
Design time, run time. If you don't create parameter what will happen
What is resilience time?
What is a filter transformation?
Which files are created during the session rums by informatics server?
What are connected or unconnected transformations?
How can we delete duplicate rows from flat files?
