why we are using level option in normalizer transformation
- 1 Answers
- 6232 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 |
when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?
Without source how to insert record to target?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to generate sequence numbers using expression transformation?
Write the prerequisite tasks to achieve the session partition?
how to duplicates from expression transformation without using sorter before that
Tell me one complex query in oracle ?
What is enterprise data warehousing?
Which is the t/r that builts only single cache memory?
what is curr val use for in sequence generator?
Teradata 
