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
- 6873 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 meant by target load plan?
What are the different components of powercenter?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Enlist the advantages of informatica.
How do you load unique records into one target table and duplicate records into a different target table?
what is $$$$?
Explain lookup transformation is active in informatica
what is diff b/t sorter t/r and agg have the option sorter property...
What are the types of schemas we have in data warehouse and what are the difference between them?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Name the different lookup cache(s)?
Explain the pipeline partition with real time example?
What are mapplets?
What is persistent lookup cache?
