Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 6511 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
What is abap? What are idocs?
Compare etl & elt?
What is Data Vault???
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
What is etl process?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What is the difference between Data Warehousing and Data Mining?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
what happens if the info.server doesn't find the session parameter in the parameter file?
What is a materialized view log?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Two default user groups created in the repository are____and_____.
