Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


why we are using level option in normalizer transformation



why we are using level option in normalizer transformation..

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

Post New Answer

More Informatica Interview Questions

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,


Explain the tuning lookup transformation - informatica

0 Answers   Informatica,


Describe data concatenation?

0 Answers  


What is status code in informatica?

0 Answers  


can we override a native sql query within informatica? How do we do it?

0 Answers  


How do you take care of security using a repository manager

2 Answers  


What is junk dimention?

3 Answers   Patni,


How many repositories can we create in Informatica??

9 Answers   IBM, Patni,


Without using Lookup & Sequence Generator, How to generate Sequence?

5 Answers   CTS,


What is polling in informatica ?

1 Answers   TCS,


following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,


Can i create a lookup table without cache.

7 Answers   iGate,


Categories