Interested to Buy Any Domain ? << Click Here >> for more details...
how can one eliminate dupliacte data with out using
distinct option?
- 5 Answers
- 10983 Views
- Patni, Wipro, I also Faced
- E-Mail Answers
Answer Posted / prabha kamaraj
Using Group by command removes all duplicates records in a
table
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the features of complex mapping?
what is SDLC way of code development?
What is the function of aggregator transformation?
What do you mean incremental aggregation?
What is a grid 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.
What is native users?
What is Data Caches size?
Separate from a database, an information bazaar, and an information stockroom?
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
How many number of sessions can one group in batches?
What is Session and Batches?
What are the types of caches in lookup? Explain them.
What are some examples of informatica etl programs?
Explain the different kinds of facts.
