Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

IBM Informatica Interview Questions
Questions Answers Views Company eMail

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 3134

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 6366

Input 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 5316

hi 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 5933

ename,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 3315





can 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 13292

how to connect two or more table with single source qualifier?

4 17730

hi 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 4696

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 5734

what is procedure to use mapping variable in source qualifier transformation? with example

1 5419

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 2626

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 4408

what is correlated query?

2 3921

what is inline view?

1 3693

What is the difference between SOURCE and TARGET BASED COMMITS?

3 3947

Post New IBM Informatica Interview Questions




IBM Informatica Interview Questions


Un-Answered Questions

Difference between BDC vs Direct Loads?

141


Write a code for passing ArrayList in Web API?

166


java program with complete 4 oops concepts implemented example

2303


Manipulation of dead wt. tester double piston type.

1003


What is the quicktest professional (qtp) testing process?

120






What is the long tail keyword?

98


As a project manager, you're responsible for maintaining and ensuring integrity for all of the following except: A. Personal integrity of others B. Project management process C. Personal integrity D. Product integrity

115


what trial balance is and how you check trial balance in Tally ERP9?

143


Does treemap allow null keys?

58


How do I know asp.net mvc version? : Asp.Net MVC

70


State benefits of Hadoop users by using Apache Ambari?

3


What is the use of serialize method in jQuery?

111


What is sorting in math?

73


What is the difference between a blog and a website?

11


how to find number of run cable laying[LT side] for transformer & alternator secondary side? [above condition for getting output power transformer to main panel side] give the example.

1098