I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
1 4025Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
3 7774Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
3 6569hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
9 8542ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
1 4344can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 16523hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
2 5921is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
3 7292Post New IBM Informatica Interview Questions
Do vectors start at 0 c++?
What are documents in mongodb?
What is Indexing? how did u implement indexing?
How do you edit chart labels in excel?
What is plug-in profiler and importance of it?
Why do we floating DC in DC system.
Explain about the page-new method?
Explain what relationship is between a process, application domain, and application?
Explain the purpose of o-ring, wearings in the centrifugal pumps?
How to Display documents in the default browser?
I am a beginner in Sap pm.Can anyone suggest me some good website to know more abt sap pm module. If anyone has any material abt it, plz mail to my mail:-urskartik.a@gmail.com
What is the best web server?
What is shift factor? Explain with example.
What is a good way to get started in doing a plant-wide steam consumption analysis?
What is the use of __ init __ py in python?