Interested to Buy Any Domain ? << Click Here >> for more details...
why we are using level option in normalizer transformation
- 1 Answers
- 6923 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
What is data movement mode in Informatica and difference between them?
How to join three sources using joiner? Explain though mapping flow.
How do you load alternate records into different tables through mapping flow?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How we can create indexes after completing the load process?
What is a repository? And how to add it in an informatica client?
Quickly characterize reusable change?
In which transformation you cannot drag ports into it?
What is a router transformation?
What is an expression transformation?
Plz can any one say me how to get the informatica certification materials and dumps
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
difference between informatica 8.1.1 and 8.6
What is domain in terms of informatica?
What is a joiner transformation?
