why we are using level option in normalizer transformation
- 1 Answers
- 6350 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
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 rank transformation in informatica
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is enterprise data warehousing?
tell me the rules and responsblites in our project(my project is development)
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is the surrogate key?
Can we create multiple integration service on single repository?
what is index?how it can work in informatica
Performance tuning in UNIX for informatica mappings?
What you know about transaction control transformation?
How to elaborate tracing level?
What is the fact table?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How we can create indexes after completing the load process?
What could be the possible resons of locks by user?
