Interested to Buy Any Domain ? << Click Here >> for more details...
why we are using level option in normalizer transformation
- 1 Answers
- 7012 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
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are session parameters ? How do you set them?
How do you update the records with or without using update strategy?
How to load last n records of file into target table - informatica
Different qualification between a related rotate toward the sky and isolates look upward?
what are the Methods For Creating Reusable Transformations?
write a query to retrieve the latest records from the table sorted by version(scd)
Partition, what happens if the specified key range is shorter and longer
How many types of sessions are there in informatica.please explain them?
Define the various join types of joiner transformation?
What is the reusable transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What do you mean by blocking transformation?
Difference between Target-based loading and constraint-based loading?
What are the tasks that can be performed using sq?
