Answer Posted / paramaguru

source qualifier---field1
connect field1 to all the 4 field in the normalizer.
normalizer: In the normalizer maker occurs as 4
it will creat automatically
NEWfield1
NEWfield2
NEWfield3
NEWfield4
NEWFIELD
GK_NEWFIELD
GCID_NEWFIELD

target:OUTPUT
connect newfield to the target output

What is the use of target designer?

1118

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1021

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1306

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1200

---

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.

2250

---

Explain the etl program with few examples.

1115

---

whats the logic to load the lower level of granularity of data to fact table.

2311

---

Differentiate between sessions and batches?

1070

---

What is the difference between informatica 7.0 and 8.0?

1054

---

how to load dimension table and fact table. plz tell me the steps.

2142

---

What are Dimensional table?

1121

---

Explain sessions?

1140

---

Enlist the advantages of informatica.

1099

---

Where is metadata stored?

1195

---

What are the components of workflow manager?

1158

---