Interested to Buy Any Domain ? << Click Here >> for more details...
we r using aggregator with out using groupby?
- 7 Answers
- 22247 Views
- HSBC, Principal Finance, I also Faced
- E-Mail Answers
Answer Posted / naresharavetis
if u use aggregator t/r without using group by function u
get one summirized result but group by option allows u get
deatil result.
for example .without using groupby u want see a releince
store sales .u will get sales of whole store but when uuse
group by u get imtemized sales result
storecode itemname sales
101 vegetable 500
101 vegetables 700
101 electronics 5000
101 electronics 10000
101 cooldrinks 200
101 cooldrinks 500
result without groupby: store sales:17400
result with groupby: vegetables sales :1200
electronics sales: 15000
cooldrinks sales: 700
| Is This Answer Correct ? | 4 Yes | 19 No |
Post New Answer View All Answers
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Explain constraint based loading in informatica
Explain the features of connected and unconnected lookup.
waht type of interface is used for testing the data in informatica
What are the designer tools for creating transformations?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the benefit of session partitioning?
What are the new features of informatica 9.x at the developer level?
What are the differences between source qualifier and joiner transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Differentiate between Load Manager and DTM?
r u done any partitions in ur project?
server hot-ws270 is connect to Repository B. What does it mean?
