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
- 6950 Views
- I also Faced
- E-Mail Answers
Answer Posted / krish
take AGG t/r and give count on price
and in router count(price)=1 and count(price)>1.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Difference between Target-based loading and constraint-based loading?
What are the tasks that source qualifier perform?
How to load the data from people soft hrm to people soft erm using informatica?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is workflow? What are the components of workflow manager?
What is source qualifier transformation in informatica?
What is meant by active and passive transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
4 yrs etl devloper roles and responsibilities?any body give solutions
What is meant by lookup transformation?
How do you set a varible in incremental aggregation
What is Session and Batches?
how many types of dimensions are available in informatica?
What is resilience time?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
