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
- 6788 Views
- I also Faced
- E-Mail Answers
Answer Posted / srinivas.medagum
When the records come from SQ each record from first one
checks for the group by port but till last record it doesnot
found .So by default as the last record considered as only
record it stores in Agg T/R.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Enlist the tasks for which source qualifier transformation is used.
Can u generate reports in Informatica?
Why update strategy and union transformations are active? Explain with examples.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explain the tuning lookup transformation - informatica
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is meant by lookup transformation?
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
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
what is unit testing?tell me proceedure
Is stop and abort are same in informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
