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
- 7059 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
Enlist the tasks for which source qualifier transformation is used.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the transformations that are not supported in mapplet?
What are pre and post-session shell commands?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Is there any target staging area in informatica not staging area
What are the advantages of using informatica as an etl tool over teradata?
What is flashback table ? Advance thanks
How to do the error handling of if ur source is flatfiles?
How we can create indexes after completing the load process?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is domain in terms of informatica?
Explain scd type 3 through mapping.
How union transformation is used?
