Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7146 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
How can we use external procedural logic in informatica?
What is full load & incremental or refresh load?
what is the meaning of upgradation of Repository?
When do we analyze the tables? How do we do it?
What are the differences between sql override and update override?
what happens if the info.server doesn't find the session parameter in the parameter file?
what is pmrep command?
SCD2 will work on only dimension tables as well as fact Table?
What are snapshots?
What are the various tools used in etl?
Can u access a repository created in previous version of Informatica?
What is the difference between round-robin partitioning and hash partitioning?
what is session partitioning?
how does the server recongnise the source and target databases.Elaborate on this
what is data modeling?
