When to use normalization transformation other than cobol
source?

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

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  


what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  


What is Session and Batches?

0 Answers   Informatica,


what is target update override and when we use it?

2 Answers   TCS,


sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,






What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


How do you take care of security using a repository manager

2 Answers  


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  


Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,


i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,


Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,


suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,


Categories