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

Scenario:- 




Below is the requirement.




Source:- 
NAME          ID                    Requirement 
RAVI            1                      (no need to repeat as it ID is 1)
KUMAR        3                     (repeat 3 times as it ID is 3)
John             4                     (repeat 4 times as it ID is 4)




Required Out Put:-




Name                   ID
RAVI                     1                   
KUMAR                3     
KUMAR                3
KUMAR                3 
John                     4
John                     4
John                     4
John                     4

Scenario 2:-




Source Data 




ID              NAME
1,2            NETEZZA,ORACLE
3,4,5         SQL Server, DB2, Teradata




Required Output:- 




ID                   NAME
1                  NETEZZA
1                  ORACLE
3                  SQL Server
3                  DB2
3                  Teradata

Question Posted / krish

Answer Posted / krish

http://netezzamigration.blogspot.com/2014/10/implementing-java-transformation-with.html

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2029

While migrating the data from one environment to another environment how would you manage the connections?

1080

What are mapplets?

1264

design of staging area?

2026

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2232

How to extract sap data using informatica?

1040

How do we call shell scripts from informatica?

1101

Under what condition selecting sorted input in aggregator may fail the session?

1118

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2104

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1160

How can we update a record in the target table without using update strategy?

1136

What is an expression transformation?

1009

What are the performance considerations when working with aggregator transformation?

1147

expain about the tune parameters?

2408

Differentiate between reusable transformation and mapplet.

1085