Answer / chandra

by using normalizer we can normalize the data .
means a single input record can be devided into multiple
data records.

This process is also called as datta pivot.

Regards
chandrababu Naidu

Answer / abdulquadir atif

Hi,

We use Normalizer for COBOL sources and also to split data,
which means de-normalizing. If you want to change columns
to rows and vice versa.

Atif

Mapplets can you use an active transformation in a mapplet,

1 Answers  

---

how will you remove the duplicate records from flat file without using sorter?

7 Answers  

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

Does an informatica transformation support only aggregate expressions?

0 Answers  

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

Tell me about informatica architecture.

2 Answers   TCS,

---

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---

Write the advantages of partitioning a session?

0 Answers  

---

In a sequential batch can you run the session if previous session fails?

4 Answers  

---

what is casual dimension?

6 Answers   IBM,

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers  

---