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
What is etl tool in hadoop?
what is the meant by Normalization and de-normalization?
what is the difference between cardinality and Nullability?
Can u access a repository created in previous version of Informatica?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
What is initial load and what is full load?
what is granularity in Data ware House?
Compare ETL & Manual development?
Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?
Explain do we need an etl tool?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
how do u implement configuration management in Informatica?
what is Forward,Reverse and Re_engineering?
What is fact? What are the types of facts?