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 4040

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 6585

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 8570

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 16548

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 5939

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 6309

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 customer connection?

397

How to release an object?

1030

Define analytics?

73

Why do we use queries?

5

Do I need java on my pc?

506




How to schedule ssas database backup

520

How do you pass a variable by value?

579

Define the names for parameters, filters etc…

206

What is the difference between interaction center winclient & interaction webclient?

559

Can you reformat a corrupted hard drive?

477

http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?

580

Can we sort hashset in java?

620

Hi 1 Question please My client is on SAP since last 3 years and now they want to migrate their asset related data with AM solution, I would like to know the steps and precaution to be taken at the time of legacy data migration and how to reconcile ABST2 report.

1563

Can I still use windows 95?

451

Pls help me to arrive the rates for centering shuttering for highbay using H-frames?

1887