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

Explain the different dimensions.

558

can you please explain me pre session and post session options?

6387

What are some examples of informatica etl programs?

540

Explain dynamic target flat file name generation in informatica

652

What are different types of transformations available in informatica?

588




What are the different clients of powercenter?

602

What is a passive transformation?

646

Whats the difference between informatica powercenter server, repositoryserver and repository?

679

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1481

What is resilience time?

655

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

606

State the differences between sql override and lookup override?

628

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6485

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

602

How big was your fact table

1320