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

Explain the difference between a data warehouse and a data mart?

0 Answers  

What is the use of transformation?

0 Answers  

performance tuning of Informatica

1 Answers  

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

Can you copy the batches?

3 Answers  

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

What is the capacity of power cube?

1 Answers  

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

How to jion 2 tables, without using any condition?

11 Answers   Amazon,

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories