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 4038

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 7784

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 6582

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 8568

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 4352

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 16545

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

 4 19491

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 5934

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

 3 7312

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

 1 6307

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

 1 3405

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

 3 5797

what is correlated query?

 2 4953

what is inline view?

 1 4609

What is the difference between SOURCE and TARGET BASED COMMITS?

 3 5418

Post New IBM Informatica Interview Questions


IBM Informatica Interview Questions


Un-Answered Questions

What is diversity factor in electric installations?

699

What is the difference between progress and meter tag?

440

what is a replica set?

5

Can we add elements to final list?

475

what is the stear deltaprinceple?

1398




Dog lies down to sleep only after observing the surroundings. Why?

541

What is proxy method?

536

How do I change cell value in excel based on condition?

337

What is "as" syntax in typescript?

1

How to Create a custom TInplaceEdit for TDBGrid ?

1992

is it possible for different brand of H.V transformers to run or operate in parallel to each other? if so how much disturbance can this affact the H.V bus bar?

1640

In how many ways can dependency injection be done?

160

What is the highest-level event class of the event-delegation model?

568

Why microsoft is important?

315

Explain about safety integrated level protection? . How it was differ from other protections ?

1254