When to use normalization transformation other than cobol source?

When to use normalization transformation other than cobol
source?

Question Posted / rohit

2 Answers
6919 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

When to use normalization transformation other than cobol source?..

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

Is This Answer Correct ?

11 Yes

0 No

When to use normalization transformation other than cobol source?..

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

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Informatica Interview Questions

what is inline view?

1 Answers IBM,

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers

Do you find any difficulty while working with flat files as source and target?

0 Answers

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers IBM,

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers NTT Data,

how to join the 2 different table with different columns in informatica?

5 Answers Accenture,

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers TCS,

Different sorts of metadata that stores in the storage facility?

0 Answers

Mapplets can you use an active transformation in a mapplet,

1 Answers

What is confirmed fact in dataware housing?

2 Answers Hewitt, TCS,

design of staging area?

0 Answers

For more Informatica Interview Questions Click Here