In a simple mapping when i use aggregate t/r with out any
condition or group by, i am getting output as only last
record in the table . can any one explain it please.........?
Answer Posted / ankit kansal
By Default informtica finds a group on the basis of your group by check boxes and returns you last row of each group when you don't specify any group by clause then it takes whole data set as a single group and returns you the last row of that whole group...
please make me correct if i am wrong..
http://deepinopensource.blogspot.in
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you mean by enterprise data warehousing?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to generate sequence numbers?
What is a surrogate key?
Explain the mapping variable usage example in informatica
what is SDLC way of code development?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What do you mean by worklet?
Mention some types of transformation?
what is the -ve test case in your project.
Did u used latest transformations of 8.6.0? for what?
Explain informatica architecture - version 8 / 9