Interested to Buy Any Domain ? << Click Here >> for more details...
why we are using level option in normalizer transformation
- 1 Answers
- 6895 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 are the types of presistent cache in look up tr.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Difference between Data and Index Caches?
What are the various types of transformation?
What is InformaticaPowerCenter?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the transformations that are not supported in mapplet?
What is an expression transformation in informatica?
how to load dimension table and fact table. plz tell me the steps.
While migrating the data from one environment to another environment how would you manage the connections?
Differentiate between reusable transformation and mapplet.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How do you use reject loader.
Design time, run time. If you don't create parameter what will happen
what are the deliverables?in your project?
