Interested to Buy Any Domain ? << Click Here >> for more details...
hw cn v elimate dublicate values from lookup without
overriding sql?
- 7 Answers
- 18022 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / honey
We can remove the duplicate values from the lookup by using
the DISTINCT clause with SQL queries.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What is fact table? Explain the different kinds of facts.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain incremental aggregation in informatica
What are the types of caches in lookup? Explain them.
What is mapplet in informatica?
How can you increase the performance in joiner transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Different sorts of metadata that stores in the storage facility?
What do mean by local and global repository?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the reusable transformation?
What is the sequence generator transformation in informatica?
What is informatica metadata and where is it stored?
