why we are using level option in normalizer transformation
- 1 Answers
- 6349 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 |
Is there any target staging area in informatica not staging area
Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.
Why update strategy and union transformations are active? Explain with examples.
Explain lookup transformation in informatica
what are the different types of transformation available in informatica and what are the mostly used ?
how the informatica server sorts the strings values in rank transformations?
How to do unit testing in informatica? How to load data in informatica ?
Clarify the aggregator change?
Do you have knowledge in ralph kimball methodology
CAN WE IMPLEMENT SCD TYPE 1 AND SCD TYPE 2 IN SAME MAPPING? IF SO HOW?
How to jion 2 tables, without using any condition?
How to delete the data in the target table after loaded.
Teradata 
