Answer Posted / priyank

We can use an aggregator. Dont to group by on any of the
columns. Add one extra output port for Count. This port
will give the total count of the records in the source file.

Can we change Dynamic to Static or Persistent cache? If so what happens?

2199

---

Explain Dataware house architecture .how data flow from intial to end?

2577

---

What is different between the data warehouse and data mart?

1055

---

How many ways are there to create ports?

1316

---

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

4143

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1617

---

What are the different types of transformation available in informatica.

1095

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1902

---

What is data caches/ index caches?

1086

---

What are the restrictions of union transformation?

1028

---

Mention a few design and development best practices for informatica?

981

---

What are data-driven sessions?

1191

---

What are different types of transformations available in informatica?

985

---

How union transformation is used?

997

---

Which version configuration tool used in ur project?

3241

---