Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7646 Views
- I also Faced
- E-Mail Answers
Answer Posted / kal_leo@hotmail.com
Hi U can eliminate duplicate records by an simple oneline
SQL Query.
select id, count(*) from seq1 group by id having
count(*)>1;
U can run this query directly on any SQL*Plus or U can
override SQL in any transformation.
Hope this is of any help.
Kal
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
what are the cubes developed in a sap bw project and what is the requirement for developing it?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Mention few test cases and explain them?
what is pmrep command?
What are the various tools used in etl?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
what is data modeling?
What is cube grouping?
can be used COM component in Informatica ?
How can we use external procedural logic in informatica?
What is etl process?
What are three tier systems in etl?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
