Answer Posted / dj

I think yes we take source based lookup.plz correct if i was wrong

What can we do to improve the performance of informatica aggregator transformation?

1090

---

What is the difference between a connected look up and unconnected lookup?

961

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1052

---

What is a snowflake schema?

990

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2128

---

What is the Process to creating lookup transformation in informatica

1038

---

What is informatica etl tool?

996

---

What is mapping debugger?

1006

---

Explain the difference between mapping parameter and mapping variable?

1032

---

what is index?how it can work in informatica

2036

---

In warehouses how many schemas are there?

1068

---

Why is sorter an active transformation?

1119

---

Explain sessions. Explain how batches are used to combine executions?

1023

---

What is status code in informatica?

1012

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4153

---