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
- 6895 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
Different circumstance which drives informatica server to expel records?
What are pre and post-session shell commands?
Is it possible to use a client with different version than that of its Informatica server?
What is the different lookup cache(s)?
What is parallel processing in informatica?
list out all the transformations which use cache?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is a connected transformation?
Performance tuning in UNIX for informatica mappings?
Target increases every day even though no new record was inserted
What is meant by pre and post session shell command?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What do think which one is the better joiner or look up?
What are the components of the workflow manager?
