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)

What are the types of Data Warehouse applications?

934

---

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.

1899

---

what is pmrep command?

2363

---

if i have a query as flat file how can we load data to target table

1335

---

What is staging area referring to?

1046

---

What is etl process. How many steps etl contains explain with example?

890

---

What is a materialized view log?

946

---

What are materialized views & where do we use them?

913

---

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

1946

---

How many steps etl contains explain with example?

877

---

what is different between sequential batch and concurrent batch and which is recommended and why?

4855

---

what make u disappointmnets in u r career

2136

---

what is a worklet?

919

---

Is apache nifi an etl tool?

906

---

Explain the key challenges that you face while performing etl testing.

944

---