Answer / jakka

Below are the ways to eliminate the duplicate records:
1.Select distinct in source qualifier
2.Based on your requirement,select and give number of
sorted ports in source qualifier and need to override the
query using order by cluase. Then use aggregator and select
sorted input as given and use group by ports
3. Use sorter to sort data and then use aggregator as
mentined in point 2.
4.Use sorter to sort data and check distinct in soter
properties.

Hope this will help you...

Jakka

Answer / 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

Answer / 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)

what are the session parameters? How do u set them?

0 Answers  

---

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,

---

How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

1 Answers  

---

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers   IBM, Saama Tech, Wipro,

---

SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,

---

What are materialized views & where do we use them?

0 Answers  

---

How to know informatica conslole password??

0 Answers  

---

Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?

2 Answers  

---

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.

0 Answers  

---

Two default user groups created in the repository are____and_____.

0 Answers  

---

How many steps etl contains explain with example?

0 Answers  

---

Explain etl mapping sheets?

0 Answers  

---