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)

How to delete data which is not in source table?

1342

---

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?

2893

---

explain the methodology of Data Warehousing?(Polaries)

2295

---

what is granularity in Data ware House?

1729

---

How many types of transformations supported by sorted input?

1224

---

Identifying the bottlenecks in various components of Informatica and resolving them.

2621

---

What are snapshots?

984

---

What are the three tiers in etl?

1113

---

What are the etl testing operations includes?

1112

---

When do we go for the tools in the market?

947

---

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

2236

---

flat filevalidation in informatica

2157

---

what is the meaning of upgradation of Repository?

3747

---

Explain about the data integration suite features?

952

---

What do you understand by the term ‘transformation’?

1039

---