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

CTS Informatica Interview Questions
Questions Answers Views Company eMail

what are the output files that the informatica server creats during running a session?

 2 9428

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

 3 7657

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

 6 15843

Which version configuration tool used in ur project?

 1 3412

how you will maintain version?

 3 9621

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

 2 4767

How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.

 1 3904

Limitation of REPLACESTR. Is there any character limitation to it.

 1 4740

I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

 2 5339

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

 1 1790

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

 1 1793

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

 1 1833

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

 1 1780

What if i will group by with some port in aggregator and will not pass the sorted values. Will the session fails tell in both cases ( if i have configured it for sorted input and if i have not configured it for sorted input).

 1 2550

Post New CTS Informatica Interview Questions


CTS Informatica Interview Questions


Un-Answered Questions

can any body give me any website for getting help on mainframe projectts in banking domain.

2216

can i get exact salary of clerk in SBI. and i want to know about promotion details .....

2124

rate of vat on gold purchase local & o.m.s. & rate of % in sale local & o.m.s.

1801

I NEED 2006&2007 RAILWAY RECRUITMENT BOARD,JUNIOR ENGINEER (SIGNAL) Q&ANSWERS,PLEASE SEND TO: kaleelbe@yahoo.com

1982

Yazaki india pvt ltd interview questions qurey related

1150

please send the last 5 years {{{JUNIOR ENGINEER - ELECTICAL, ELECTRONICS RRB CHENNAI}}} TECHNICAL question papers TO MY EMAIL ID megalasri@gmail.com I AM BE APPEARING STUDENT CAN I FILL THE FORM OF SECTION ENGG i have to face written test of rrb for the post of J.E (signal), so please send me the old/model question papers for this post to my e-mail ? electronics).for tecnical test question which book is preferred. Railway recruitment board (Changighar examination 2006 & 2005&2004 question papers. Wtion to Your Friend] RRB examination.so which book I have to refer?

2204

Which is the latest version of adobe photoshop?

148

i am mathematics student. i have selected on sbi cerck on20 oct.ple any one before me has exp of PI ple help me waht they ask in PI.and what about mathematics ques ple contact on shahkr786@gmail.com

2280

what are you planning on your next b'day/what have you planned on your next b'day ..??

1882

What is the latest version of biztalk server? : biztalk server

1065

How to retrieve images in sql server database through vb.net?

1082

What is the penal interest charged in your bank? Have you ever refunded it?

1255

Explain how AI models create realistic game physics.

184

What is the client no of SAND BOX.GOLDEN CLIENT, UNIT TESTING,ENDUSER TRAINNING AND PRODUCTION SERVER?????

2288

I want recent question papers. Now am preparing for BPO interview. please send the papers..

3121