why we are using level option in normalizer transformation
- 1 Answers
- 6213 Views
- TCS, Wells Fargo, I also Faced
- E-Mail Answers
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 the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
How to run a session, which contains mapplet?
How to fix the etl bugs..Tell me the process?
tell me the rules and responsblites in our project(my project is development)
Quickly characterize reusable change?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
How will you display "Mr" for male & "Mrs" for female in target table?
Explain informatica architecture - version 8 / 9
How can you increase the performance in joiner transformation?
What are session parameters ? How do you set them?
Teradata 
