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
- 4767 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
Explain how to import oracle sequence into informatica?
What is domain in terms of informatica?
What are the components of Informatica? And what is the purpose of each?
Tell me about Propagate functions in informatica
State the differences between sql override and lookup override?
Can you use flat files in Mapplets.
Different qualification between a related rotate toward the sky and isolates look upward?
How to differentiate between the active and passive transformations?
How to update or delete the rows in a target, which do not have key fields?
how to load rows into fact table in data warehouse
What is data caches/ index caches?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the way to execute pl/sql script using informatica mapping?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
COM components can be used in Informatica
