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
- 4244 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 |
how to join two flat files in informatica?
How to do unit testing in informatica? How to load data in informatica ?
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
what is materialized view?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
How do you set a varible in incremental aggregation
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
What are the session parameters?
In Which scenario did u used Incremental loading?
Different types of Power center errors?
Teradata 
