Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 1 Answers
- 4675 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
How can we delete duplicate rows from flat files?
What are different types of transformations available in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to update source definition?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is the function of union transformation?
How many input parameters can exist in an unconnected lookup?
Target increases every day even though no new record was inserted
What is primary and backup node?
Explain sessions. Explain how batches are used to combine executions?
What is the need for an etl tool?
What is the function of aggregator transformation?
Where is metadata stored?
What is data transformation manager process?
What is status code in informatica?
