CTS Informatica Interview Questions Answers, CTS Placement Papers, CTS Technical, HR Interview Questions, CTS Aptitude Test Questions, CTS 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

CTS Informatica Interview Questions

Questions Answers Views Company eMail

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

2 9005

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

2 7233

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

6 14949

Which version configuration tool used in ur project?

3156

how you will maintain version?

3 9092

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 4389

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 3584

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

1 4477

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 4971

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

1559

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 ?

1595

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.

1630

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.

1578

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 2256

Post New CTS Informatica Interview Questions

CTS Informatica Interview Questions

CTS Informatica Interview Questions (74)

Un-Answered Questions

Can you explain collaborative filtering?

374

What does f10 do?

520

in each media we require to use SLS? how to proceed?

692

What is spring boot starter tomcat? : Spring Boot

410

Where do you deploy the additional files used in your web part, like css or javascript files, and how do you use them in your webpart?

621

What is the command used to create a database using php and mysql?

1063

What is the difference between eap and eap-tls?

767

Can we change web.config settings from iis?

995

How can you use spring to resolve collaborators for your bean?

341

What is loop in data warehousing?

1054

What are dangling pointers? How are dangling pointers different from memory leaks?

1203

What is a technical analyst?

966

Where is the best place to write the logic in ax?

190

Actinium is often considered a rare and scarce element. How does its rarity impact its industrial uses and research purposes?

467

what is the sludge current

2018