Interested to Buy Any Domain ? << Click Here >> for more details...
Eliminating of duplicate records without using dynamic lookups
- 3 Answers
- 7662 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 the difference between etl tool and olap tools?
What is a mapping?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What are the etl testing operations includes?
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.
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
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?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
How many steps etl contains explain with example?
what is pmrep command?
Explain me ETL project architecture in Detail?
how do u extract data from different data sources explain with an example?
what is the difference steps for data modeling?
where we cannot use sorter Transformation. if we use then we will not get correct data?
Identifying the bottlenecks in various components of Informatica and resolving them.
