Answer Posted / venkat

S->S.Q->Aggr->Rtr->T1
->T2


Where Aggr take group by option
Rtr group1 condition reccount>1..........>T1
Rtr default group to....................>T2


T1 records are unic records
T2 records are duplicate records

Explain sessions?

977

---

Define update strategy?

1108

---

Enlist the tasks for which source qualifier transformation is used.

980

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1026

---

Explain pushdown optimization and types in informatica

1014

---

What are the advantages of using informatica as an etl tool over teradata?

968

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2349

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1994

---

How to extract the informatica rejected data?

1160

---

What is a filter transformation and why it is an active one?

905

---

What are the types of schemas we have in data warehouse.

891

---

what is degenerated dimension?

3869

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2138

---

what is diff b/t sorter t/r and agg have the option sorter property...

2128

---

Explain sessions and how many types of sessions are there?

954

---