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 4677Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
3 8692Input 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 7544hi 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 10497ename,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 5025can 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 17636hi 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 6781is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
3 8481Post New IBM Informatica Interview Questions
What is intact assay method development.....?
How do I check my magento version?
What are 3 main differences between flexgrid control and dbgrid control?
How do you stop startup programs on windows 7?
What happens when one of the resources in a stack cannot be created successfully in AWS OpsWorks?
It is possible to use RPA for any Rule-based task?
What is the architecture of django?
How do I merge table rows in word?
Why reactors use before incoming of ac vvfd drive?
What are the four types of annotations?
How do I delete a dll file?
Explain the major components of apache storm system?
How does hibernate distinguish between transient (i.e. Newly instantiated) and detached objects?
Explain the front controller class of spring mvc.
Tell me about inheritance in prpc?