SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT
BUSINESS LOGIC WE CAN APPLY.
source table target table
------------ ------------
c1 c2 c3 c1 c2 c3
-- -- -- -- -- --
1 A J 1
2 B K 2 A
3 C L 3 B J
4 D M 4 C K
5 E N 5 E L
F M
N
- 0 Answers
- 1860 Views
- Infotech, I also Faced
- E-Mail Answers
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
How can we eliminate duplicate rows from flatfile,explain?
what is flat file override?
What is meta data and system catalog?
How to delete duplicate row using informatica?
What are the two modes of datamovement in informatica sever?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
in realtime which situations u can use unconnected lookup transformation
HOW DO YOU CONNECT TO REMOTE SERVER ?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
How do you load first and last records into target table?
Design a mapping to get year of join for each employee.
Teradata 
