Interested to Buy Any Domain ? << Click Here >> for more details...
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.........?
- 4 Answers
- 6763 Views
- I also Faced
- E-Mail Answers
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 is workflow manager?
What are the different versions of informatica?
Under what condition selecting sorted input in aggregator may fail the session?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What do you understand by term role-playing dimension?
Can we get 1st record through Informatica(without sequence number).
What is the use of transformation?
How can one identify whether mapping is correct or not without connecting session?
How to configure mapping in informatica?
What is an unconnected transformation?
Which are the different editions of informatica powercenter that are available?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Differences between version 7.x and 8.x.
