Eliminating of duplicate records without using dynamic lookups
Answer Posted / pooja ahmed
1. you can you use sorter transformation .... in that you
select distinct option
2. use agg trans .... in that go for group by
usi8ng above metyhod you can remove duplicate rec...
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
How many steps etl contains?
what is granularity in Data ware House?
What are the modules in Power Mart?
what are the concerns of OLTP and DSS systems?
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Explain about etl data integration software?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
What is etl tool in hadoop?
In Which Transformation We Can Use Having Clause In Informatica?
how do use session mapping parameters ?(in which transformation)
What are the etl testing operations includes?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?