Interested to Buy Any Domain ? << Click Here >> for more details...
why we are using level option in normalizer transformation
- 1 Answers
- 6954 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
How to do the error handling of if ur source is flatfiles?
What is data transformation manager process?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What will be the approach?
Explain why we use partitioning the session in informatica?
Where do we use mapping variables in informatica?
What are the different clients of powercenter?
Enlist the advantages of informatica.
What is target load order?
What are session parameters ? How do you set them?
Define joiner transformation?
How can one identify whether mapping is correct or not without connecting session?
What is Session and Batches?
Define filter transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
