When to use normalization transformation other than cobol
source?
Answers were Sorted based on User's Feedback
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 |
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 |
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.
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
What is Session and Batches?
what is target update override and when we use it?
sorce is a flatfile only 1st and last row should insert to target how will u do?
What is the main difference between a Joiner Transformation and Union Transformation?
How do you take care of security using a repository manager
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
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.
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?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
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