why we are using level option in normalizer transformation
Answer / 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 |
What is mapplet in informatica?
what is parallel querying and what r hints.
what is the Default Source Option For Update Strategy Transformation?
What do you understand by SOA of Informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How to send duplicates to one target and unique rows to one target?target is empty
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
Parameter and variable differences
how to work with mapplet designer in informatica?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the rank caches?