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 |
which one is better either active or passive transformation in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica
What is meant by incremental aggregation?
What is status code?
can we see default group,when we use router?if yes how?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
what is unique constraint error ?
how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me
i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81