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


Scenario:-  Below is the requirement. Source:-  NAME     &nbs..

Answer / krish

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

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the different types of repositories created using informatica?

0 Answers  

when will we go for unconnected lookup transformation in Informatica?

6 Answers   CTS, IBM,

How many joins in Informatica

5 Answers   CSC,

What is data merging,data cleansing,sampling?

4 Answers  

What is target update override

2 Answers   CTS,

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

how can we use sorter transformation in joins?

5 Answers   IBM,

How to extract the informatica rejected data?

0 Answers  

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

Enlist the various types of transformations.

0 Answers  

Mention some types of transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories