what is normalizer transformation?
Answers were Sorted based on User's Feedback
Answer / mike
sorry... there was a correction...Normalizer is an active
connected transformation...
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sbvp
it is used to import cobol files . and it acts like a
default sq for retrieving cobol sources. and main advantage
from normalizer is to do a data pivoting.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / mike
It is a passive connected transformation which is used to
extract dat from cobol source. By using normalizer
transformation we can create multiple outputs from a single
input this is called PIVOT
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sankar
this is type an active t/r which allows to read the data
from cobol sources, normalizer t/r acts like a source
qualifier while reading the data from cobol source.
this is converting a single input record into multiple
records
| Is This Answer Correct ? | 3 Yes | 0 No |
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
What are the join types in joiner transformation?
what are challenges that you faced in testing? give solution to it?
How union transformation is active ?
in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address
Can any one explain or sujjest some sites for scd mappings.Thank you
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
explain about session partitions ?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
What are the types of schemas we have in data warehouse and what are the difference between them?
in which situations do u go for scds ?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?