Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 3357

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 6747

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 5702

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 6647

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 3630





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 14424

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

4 18268

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 5054

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

3 6169

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

1 5661

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

1 2843

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 4789

what is correlated query?

2 4185

what is inline view?

1 3946

What is the difference between SOURCE and TARGET BASED COMMITS?

3 4363

Post New IBM Informatica Interview Questions




IBM Informatica Interview Questions


Un-Answered Questions

I am teja. I am studying Msc(tech) Electronics and Instrumentation (3years course) in Andhra university. But my course is not recognised by UGC and AICTE. Please tell me the job opportunities after this course. And i fineshed PLC course in IGIAT ,Vizag.Also complted my short term coure in SCADA, Seimans WinCC in ATI,Hyd.After Msc can i join Mtech for good job? or phd. How i can get good job in INdustrial Automation Side. Please give replay.Because this is my life matter.

1258


How do you flip words in excel?

102


What are the RBI rules has to follow by a bank for online precesseing. ?

1355


What is an embedded system?

220


any one please tell taht what type questions will be asked in BHEL interview, i am having interview on 24th Dec, please send this to mail pradeepsistam@yahoo.co.in

1149






How do you create a box in excel 2016?

85


How to fetch data from database in codeigniter?

125


How do you stop spam email?

160


How do you assign an address to an element of a pointer array ?

235


What are private methods in python?

183


What is the use of pycharm?

209


What is geographical information in the sap bw?

212


WHAT IS START TO INDUCTION MOTER IN STAR TO DELTA OF >5HP ?

1055


Define select, insert, create, delete, update, drop keywords

271


What are the PeopleSoft components for the Web Server? 

815