Interested to Buy Any Domain ? << Click Here >> for more details...
why we are using level option in normalizer transformation
- 1 Answers
- 7008 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 |
How you load distinct records into one target and duplicate records into another target?
How many number of sessions that u can create in a batch?
What is diff joiner and lookup
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How to extract original records at one target & Duplicate records at one target?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
What are pre and post-session shell commands?
What are the types of data warehouses?
Describe data concatenation?
One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?
how to load duplicate row in a target
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Teradata 
