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

In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure?

Answer Posted / ram

Create normaliser...
derive 2 ports
col_1 occurence=2
col_2 Occurence=2
now you will get four input ports..

col1 -->col_1
col1---> col_1

col2--->col_2
col3--->col_2

connect two output ports from normaliser to Target..

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sorter transformation?

1109


What is olap (on-line analytical processing?

1110


What is InformaticaPowerCenter?

1177


What are the guidelines to be followed while using union transformation?

1207


How big was your fact table

1861


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2174


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1080


difference between repository database and repository service?

1224


What are the performance considerations when working with aggregator transformation?

1209


What is primary and backup node?

1174


What you know about transaction control transformation?

1057


How would you join a node to the already existing domain?

1180


What is the function of look up transformation?

1175


What does “tail –f” command do and what is its use as an Informatica admin.

1147


According to his methodology what all you need before you build a datawarehouse

1801