Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7079 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikram
To eliminate duplicate we use Source,Source qualifier,Look
up T/N, router T/N AND Target.. In This Case we use dynamic
cache
BUT USE
example emp table consist of i.d salary,name dept no.
eliminating the duplicates of dept no.
Source,Source Qualifier,Sorter T/N,Expression T/N,Router T/N
And split target in to two as duplicates and distinct
we have to create 3attributes in expression T/N AS
V_pre_deptno v_flag 0_flag
give condition as v_pre_dept no = dept no
v_flag= IFF(dept no = v_pre_deptno,1,0)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain about enterprise scalability and roi of data integration suite?
What are the differences between sql override and update override?
what is the difference steps for data modeling?
How many types of transformations supported by sorted input?
Can there be sub steps of etl steps?
how do u really know that paging to disk is happening while u are using a lookup transform?
Identifying the bottlenecks in various components of Informatica and resolving them.
Difference between flat files and relational sources?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Explain different types of partitioning?
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)
what are the concerns of OLTP and DSS systems?
Two default user groups created in the repository are____and_____.
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
