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. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Hi,
In source I have records like this
No name address
10 manoj mum
10 manoj dilhi
20 kumar usa
20 kumar Tokyo
I want records in target like shown below
No name addr1 addr2
10 manoj mum dilhi
20 kumar usa Tokyo

If it is reverse we can do this by using Normalizer
transformation by setting occurance as 2.
Somebody will say use denoralization technique. But as of my
knowledge I couldn’t find any denormalization technique. Is
there any concept like that?
I tryid this seriously but I could find any idea to
implement this.
Can any one please help me ?
Advance Thanks

Question Posted / honey

Answer Posted / honey

I think this is the concept of scd type 3

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we change Dynamic to Static or Persistent cache? If so what happens?

2189

What do you mean incremental aggregation?

1051

What are the tasks that can be performed using sq?

1074

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

2103

How to generate or load values in to the target table based on a column value using informatica etl tool.

1050

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1021

Explain the different dimensions.

943

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1937

Explain the pipeline partition with real time example?

1121

How can you increase the performance in joiner transformation?

1181

State the limitations where we cannot use joiner in the mapping pipeline?

1042

What are data-driven sessions?

1181

Write the different tools in the workflow manager?

1046

What is intricate mapping?

1172

How can informatica be used for an organization?

1192