why we are using level option in normalizer transformation
Answer Posted / lokesh
If you want to see result in quarterly based with all other information like location, branch then we can go for normalizer transformation.
Your normalizer transformation looks like this for above example:
Field Level Occurs Description
Location 1 0
Branch 2 2 In each record we can see branch detail occurs two times
result 2 4 For each branch 4 times we can see quarter result, so in a record 4(occurs) X 2 (level) = 8 times
It automatically create input/output port depends on your level and occurs. Also generates some output key ports. You can see more detail on key port in help material.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the hint? how to use it to reduce the query processing in program?
Explain direct and indirect flat file loading (source file type) - informatica
explain about unit testing? in real time?
What is a surrogate key?
What are the different ways to implement parallel processing in informatica?
What are the main issues while working with flat files as source and as targets ?
What is union transformation in informatica?
Partition, what happens if the specified key range is shorter and longer
Why sorter is an active transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Differentiate between a repository server and a powerhouse?
What will be the approach?