http://netezzamigration.blogspot.com/2014/10/implementing-java-transformati

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

1 Answers
4850 Views
Cognizant, I also Faced
E-Mail Answers

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.

1009

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2186

Explain the different lookup methods used in informatica?

1098

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2797

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2128

What is workflow? What are the components of workflow manager?

1232

Sequence generator, when you move from develoment to production how will you reset

2127

How does a rank transform differ from aggregator transform functions max and min?

1263

What are the types of caches in lookup?

1096

What is a code page?

1220

What is a standalone command task?

1256

What is the sequence generator transformation in informatica?

1266

have u done any performance tuning? how u ll do?

2366

Briefly define a session task?

1197

What is a surrogate key?

1156