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
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
What is dimensional table? Explain the different dimensions.
What is dynamic cache?
What are the advantages of informatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Write the prerequisite tasks to achieve the session partition?
Why do you use Mapping Parameter and mapping variable?
What are the main issues while working with flat files as source and as targets ?
What are the types of presistent cache in look up tr.
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Where do we use mapping variables in informatica?
What is olap (on-line analytical processing?
What is the difference between stop and abort in informatica
What is workflow monitor?
How to update or delete the rows in a target, which do not have key fields?
What are the differences between oltp and olap?