Answer Posted / cool

use sorter transformation with ascending,sequence and filter....

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1180

---

How can we delete duplicate rows from flat files?

1311

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2246

---

What is the format of informatica objects in a repository?

1075

---

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

4252

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2313

---

How an expression transformation differs from aggregator transformation?

1089

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1339

---

What is meant by lookup transformation? Explain the types of lookup transformation?

1022

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6282

---

Can you use flat files in Mapplets.

2715

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1141

---

How to partition the Session?

1154

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2126

---

What is a dimensional model?

1034

---