Eliminating of duplicate records without using dynamic lookups
- 1 Answers
- 3816 Views
- I also Faced
- E-Mail Answers
Answer Posted / murthy
use distinct at sql override,use agrgregator etc
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
how do u implement configuration management in Informatica?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Can u access a repository created in previous version of Informatica?
What is etl process?
how to connect to a flatfile through ftp in informatica
what is the use of server manager?
where is the cache (lookup, index) created and how can you see it.
What is etl tool in hadoop?
Can we create Hierarchies in generic datasources?
State the differences between shortcut and reusable transformation
Define slowly changing dimensions (SCD)?
What is partitioning? Explain different types of partitioning?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what happens if the info.server doesn't find the session parameter in the parameter file?
What is tracing level? How many types of transformations supported by sorted input?
