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...

1)can anyone explain how to use Normalizer transformation
for the following scenario

Source table | Target Table
|
Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh
Ramesh 68 82 78 | ENG 68 73 81
Himesh 73 87 89 | MAT 82 87 79
Mahesh 81 79 64 | ART 78 89 64
|
please explain what should be
the normalizer column(s)
The GCID column

2)Also please explain the Ni-or-1 rule.

Answer Posted / murthy

I'm not expert , actually i'm a new commer on datastage
i think this problem can be achieved by using pivot stage
because it converts the multiple columns data format in to
the multiple rows format, so i think it will be useful for u
thanks
murthy

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mapping debugger?

938


How to do unit testing in informatica?

1121


Design time, run time. If you don't create parameter what will happen

1792


What is source qualifier transformation in informatica?

940


How might one distinguish in the case of mapping is right or not without associating session?

1017


what are factless facts? And in which scenario will you use such kinds of fact tables.

1736


What if the source is a flat-file?

1039


expain about the tune parameters?

2332


What is the difference between writing a joiner query in ANSI style and THETA style?

2319


What does reusable transformation mean?

1065


Write the program through which the records can be updated?

933


How you prepared reports for OLAP?

1542


Informatica settings are available in which file?

935


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1505


What is informatica etl tool?

938