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 3169

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 6444

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 5380

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 6053

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 3357

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 13446

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

4 17828

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 4761

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

3 5818

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

1 5464

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

1 2661

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 4478

what is correlated query?

2 3967

what is inline view?

1 3737

What is the difference between SOURCE and TARGET BASED COMMITS?

3 4025

Post New IBM Informatica Interview Questions

IBM Informatica Interview Questions

Un-Answered Questions

What is pigeon update?


What is true about localstorage?


what is recommended way for spawning threads from a servlet in tomcat?


How to apply 'c' license and also explain what is difference between 'c' and 'b'license.i am also working in one of the private company.i have finished my diploma in 2014 .i have already finished in ITI electrician course.....


What is given by the definition in BIL IMP/PF = 950/395 kV. This was found in a name plate of a power transformer.


What are the master/detail reports?


What do you understand by “performance tuning of db” & what are the different areas where we can perform tuning?


Can I activate windows 10 with windows 7 key?


What do you mean by fdma?


What is meant by stator?


What is an adorner?


What is decorators?


What do you mean by breadth first search (bfs)?


How do I escape a reserved word in oracle?


What are the various qualifier option or what are the various import options? : transportation management