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 6186

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 4974

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

6 9643

Which version configuration tool used in ur project?

1959

how you will maintain version?

3 5695





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 1984

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 1537

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

1 1576

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 2004

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

392

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 ?

396

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.

397

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.

480

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).

382

Post New CTS Informatica Interview Questions



Un-Answered Questions

Can anyone share/send me QTP 8.2 Crack as I had it before but now it's virus affected. Pls send me on Sawale.vijay@gmail.com Thanks, ~Vijay

1917


What is the difference between declaring a variable by constant keyword and #define ing that variable?

1581


one message is sent to target but it si not reached,2nd messgae is reached, while idoc adapter using ?how to slove it?

162


how to remove the quantity of metal 1 and metal 2 in concrete

647


1- Explain about HPM 2- What is the FSC and explain the configuration of FSC 3- explain the complete loop of vibration, how it works (field to control room) 4- What is the use of proxymitter? 5- During job your partner effected with H2S then what you have to do. 6- what type of gland packing uses when valve glind is leaking.

1449






I WANT YHE TECHNICAL AND ELECTRICAL SPECIFICATIONS OF 2x4MW 11KV 2x10MW 11KV 2x25MW 11KV 2x100MW 11KV HYDEL POWER PLANT i.e PROTECTION SYSTEM,MONITORING,CONTROL SYSTEM,GENERATION,SYNCHRONISATION,METERING PLEASE SEND THE DETAILS TO MY MAIL ID SPRAVEEN_222@YAHOO.CO.IN

796


How to calculate the Harmonics losses in terms of cost/unit.

766


When CS-CVS should be used?

1630


what are the launch find options of instance?

725


1. If 8.35%Z means the percentage impedance of 132kV-line from power company, we will like to reconfirm its base capacity.

718


Hello SAP FICO consultants, I am Amreshkumar i have completed my BBA in 2009 and currenly appearing for M. com 2nd year & recently completed my SAP FICO module, can anybudy please suggest me how to find job on fresher level? Is there any company who recruites freshers OR is there any consultancies who recruites freshers. please help me.... Suggest me your views on my E-Mail ID: g.amresh@gmail.com ... Thanks...

696


What do you mean by effect of noise on carrier signal & what is noise segment

3412


What is the Procedure of Import & Export

818


What do you mean by Adjustment

650


I am DD. I am working as a Tester in e-learning company? IS there scope for content testing? or i have to change to software testing. pls guide me...

727






CTS Informatica Interview Questions
  • C (31)
  • STL (1)
  • OOPS (10)
  • C++ General (12)
  • ActiveX (1)
  • Delphi (1)
  • PHP (2)
  • Programming Languages AllOther (15)
  • JavaScript (2)
  • VB Script (2)
  • JSP (1)
  • Shell Script (2)
  • Ruby on Rails (1)
  • AngularJS (2)
  • UDP (1)
  • Networking Administration (2)
  • Networking AllOther (3)
  • Visual Basic (2)
  • C Sharp (8)
  • ASP.NET (22)
  • VB.NET (3)
  • COM+ (1)
  • IIS (1)
  • Crystal Reports (3)
  • BizTalk (1)
  • Dot Net Framework (2)
  • Dot Net General (5)
  • Microsoft Related AllOther (1)
  • Oracle General (11)
  • Architecture (1)
  • Database Management (2)
  • Oracle AllOther (1)
  • SQL Server (14)
  • MySQL (1)
  • DB Architecture (2)
  • DB Administration (6)
  • SQL PLSQL (17)
  • Databases AllOther (3)
  • Windows Threads (1)
  • Windows General (1)
  • Windows AllOther (5)
  • Linux Commands (2)
  • Linux Threads (1)
  • Unix Commands (8)
  • Unix AllOther (1)
  • Solaris Commands (4)
  • Solaris AllOther (2)
  • RTOS AllOther (1)
  • Operating Systems General Concepts (3)
  • Data Structures (2)
  • WinRunner (9)
  • Load Runner (11)
  • QTP (90)
  • Test Director (4)
  • Rational TestSuite (1)
  • Silk Test (2)
  • Automation Testing AllOther (4)
  • Manual Testing (146)
  • QA Concepts (12)
  • Mobile Testing (2)
  • Test Cases (12)
  • Test Documents Reporting (2)
  • Testing AllOther (9)
  • Servers AllOther (1)
  • COBOL (27)
  • JCL (19)
  • CICS (5)
  • DB2 (19)
  • IMS (1)
  • Natural (1)
  • MVS (3)
  • VSAM (6)
  • QSAM (1)
  • IBM MainFrame AllOther (4)
  • RPG400 (27)
  • DB400 (1)
  • IBM AS400 AllOther (17)
  • Core Java (41)
  • Advanced Java (1)
  • EJB (3)
  • Servlets (6)
  • Struts (6)
  • JDBC (7)
  • J2EE (3)
  • Weblogic (8)
  • Java Networking (2)
  • Java J2EE AllOther (5)
  • Java Related AllOther (2)
  • MQSeries (1)
  • Middleware AllOther (1)
  • HTML DHTML (2)
  • Web Related AllOther (5)
  • Teradata (8)
  • Business Objects (13)
  • Cognos (17)
  • Informatica (74)
  • Crystal Enterprise Suite (2)
  • Ab Initio (10)
  • Data Stage (41)
  • SAS (11)
  • Micro Strategy (1)
  • ETL (3)
  • Data Warehouse General (5)
  • HR Questions (21)
  • Design Patterns (1)
  • Project Management (1)
  • Version Control AllOther (2)
  • SAP Basis (8)
  • SAP ABAP (28)
  • SAP SD (14)
  • SAP MM (1)
  • SAP FI CO (25)
  • SAP CRM (1)
  • SAP SRM (4)
  • SAP Business Warehouse (3)
  • SAP Security (7)
  • SAP Business Objects BO BOBJ (2)
  • Siebel (2)
  • Oracle Apps Technical (7)
  • Oracle Apps Financial (1)
  • Cryptography General (1)
  • WebMethods (4)
  • SeeBeyond (17)
  • JCAPS (2)
  • Civil Engineering (1)
  • Mechanical Engineering (1)
  • Electrical Engineering (18)
  • Electronics Communications (22)
  • Aeronautical Engineering (1)
  • Industrial Engineering (1)
  • Engineering AllOther (4)
  • Business Administration (1)
  • Banking Finance (4)
  • Human Resources (1)
  • Business Management AllOther (1)
  • Audit (1)
  • CompanyAffairs CS (1)
  • Taxation (1)
  • Accounting General (5)
  • Accounting AllOther (11)
  • Call Centre AllOther (11)
  • UPSC Political Science (1)
  • RRB (1)
  • BSRB Clerical (1)
  • Group I (4)
  • Group II AllOther (1)
  • APPSC AllOther (2)
  • General Knowledge_Current Affairs (2)
  • Tourism Hotel AllOther (1)
  • Everything Else AllOther (4)
  • English (6)
  • General Aptitude (102)
  • Puzzles (10)
  • Placement Papers (28)
  • CCNA (4)
  • Sun Certifications (3)
  • CISA Certification (1)
  • Oracle Certifications (2)
  • Certifications AllOther (7)
  • H1B Visa (3)
  • L1 Visa (3)
  • USA Dependent Visa H4 Visa (1)
  • Australia Visa (1)
  • C Code (1)
  • C++ Code (2)
  • J2EE Code (1)
  • GATE (1)
  • IIT JEE (1)
  • MAT (1)
  • GMAT (1)
  • C C++ Errors (1)
  • Oracle Errors (4)
  • SQLServer Errors (1)