IBM Informatica Interview Questions Answers, IBM Placement Papers, IBM Technical, HR Interview Questions, IBM Aptitude Test Questions, IBM Campus Placements Exam Questions

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 4694

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 8721

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 7579

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 10555

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 5042

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 17664

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

4 20799

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 6806

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

3 8526

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

1 7228

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

1 3958

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 6848

what is correlated query?

2 5770

what is inline view?

1 5251

What is the difference between SOURCE and TARGET BASED COMMITS?

3 6626

Post New IBM Informatica Interview Questions

IBM Informatica Interview Questions

IBM Informatica Interview Questions (179)

Un-Answered Questions

How many types of resources available in wpf?

156

i am new to this tax system if you don't mine "please help me"

1907

How do I change colors in visual studio 2013?

657

What Amazon redshift built for ?

What techniques are used in Generative AI for image generation?

which taype question pattern in hr round in telecom feild.

2269

What is meant by hot spots? : abap data dictionary

1047

Is linux really better than windows?

862

How do I fix 0xc000007b?

766

Hey guys anyone plzzz tell me the syllabus for Vizag Steel Plant (IT & Mechanical Streams)........ And Aslo plzz send the materials or previous papers of vizag Steel Plant Management Trainees for both IT & Mechanical Streams......... plzzzzzzz......... Plzzzzzzz

2898

What is p table in angular?

724

Describe Hooke's Coupling and its uses.

1215

What are the restrictions that are applied to the java static methods?

947

Give ONE reason for Balance Sheet to be out of balance

1986

Why I am getting this error when dropping a database in ms sql server?

1037