Interested to Buy Any Domain ? << Click Here >> for more details...
wat transf shud i use to achieve this
id sal id sal sum
src-1 20 tgt 1 20 40
1 20 1 20 40
2 15 2 15 35
2 20 2 20 35
- 2 Answers
- 5603 Views
- I also Faced
- E-Mail Answers
Answer Posted / uma
Source -> SQ -> Agg T/F to get sum (group by id) -> Joiner (to join SQ and output of aggr transformation) -> Target
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
Enlist few areas or real-time situations where informatica is required.
Does an informatica transformation support only aggregate expressions?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
what is informatica metadata?
can we override a native sql query within informatica? Where do we do it?
difference between informatica 8.1.1 and 8.6
can u any challenge your project?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to update or delete the rows in a target, which do not have key fields?
What is rank transformation?
Different sorts of metadata that stores in the storage facility?
Partition, what happens if the specified key range is shorter and longer
What is status code in informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
