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
- 4674 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer / krish
http://netezzamigration.blogspot.com/2014/10/implementing-java-transformation-with.html
| Is This Answer Correct ? | 2 Yes | 0 No |
define galaxy repository in informatica
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
What do you mean incremental aggregation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Do you have knowledge in ralph kimball methodology
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
How can yoU improve session performance in aggregator transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How to delete duplicate row using informatica?
Teradata 
