Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / aswin
use aggregator and do not apply any aggregation function, it will return only last row in the group..if you dont provide any groupby and aggregate value it will return only last row..so you can aviod dups
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How to generate sequence numbers?
Is it possible to revert a global repository to local one and why?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Separate from an archive server and a powerhouse?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the popular informatica products?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is a transaction control transformation?
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 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?
How can you generate reports in informatica?
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.
