Answer Posted / prathap

IF GROUPBY IS NOT SELECTED INFORMATICA SERVER UNDERSTANDS WHOLE TABLE AS A ONE GROUP AND ITS GIVE LAST RECORD OUT

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9811

---

How do you load first and last records into target table?

1143

---

What differs when we choose the sorted input for aggregator transformation?

1008

---

Why do we need informatica?

973

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1116

---

What is incremental aggregation?

1063

---

What is Data Caches size?

1075

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1143

---

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

4132

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1093

---

Briefly explain the aggregator transformation?

985

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1887

---

EXL informatica Questions

1360

---

What is a stored procedure transformation?

1036

---

Explain why we use partitioning the session in informatica?

1072

---