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

  • Deloitte aptitute test questions (4)
  • Deloitte interview questions (285)
  • Deloitte placement papers (3)
  • Deloitte technical test questions (12)



Deloitte Informatica Interview Questions
Questions Answers Views Company eMail

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 20505

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 14452

What is checksum termnology in informatica? Where do you use it ?

3 18618

What is the term PIPELINE in informatica ?

7 24073

What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance

14 19262





How to handle changing source file counts in a mapping?

3 10775

What are set operators in Oracle

3 11193

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

9 9934

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

21 19790

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

2 9056

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

2 13175

What is the difference between IN and Exists in Oracle?

3 9930

Can we have a Mapping without a Source Qualifier?

14 27848

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 8048

You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 17199

Post New Deloitte Informatica Interview Questions




Un-Answered Questions

I am working in IT sector and also doing regular MBA so want to know tricks regarding management of Job and Education on same time? I get some tricks here by Internet Surfing http://tinyurl.com/ycrm35w Someone have any more ideas?

1086


In ups static switch if i gives the supply at output end it will open the circuit in stactic switch or not if it will open then how it operates.

898


why should i declare foreign key constraint as self relation instead of binary relation in tables ?

696


what is the general pattern of explanation of projects in interview, can u ans me plz.......... ex: online banking application

675


pls tel me the electric train traction motors name plate details like rpm,torue,voltage,amps,watts..ect..

697






Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

831


1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time? 1. What are environment variable, job parameters? 2. What is the relationship between the tables in oracle? 3. How can u create the sequence? 4. What are the client components? 5. Tell me about the Data stage administrator? 6. Tell me about the Data stage Manager? 7. What is joining? 8. What is difference between grep command and fgrep command? 9. What is run time column propagation? 10. How to open the file? 11. How do you cleanse the data in your project? 1. Using which stage raw binary converted into dataset? 2. Which stage is used to read the data into external application? 3. Can we convert dataset into raw binary 4. XML path? 5. When we use the hash partition in aggregator stage? 6. How many reject links in transformer stage? 7. Data stage debugger available in which jobs? 8. Tell me two parts of data set? 9. What is the function used for null handling in modify stage? 10. Default execution mode for exception handler? 11. Maximum exception handler allowed in sequence?

2169


How Suspicion of Phage infection occurs?

747


Which plant fossil is the oldest among the others those found by archeologists?

677


Can i please VHDL code for D-Latch with clear input ?? (HINT: Set up a “Process” with appropriate sensitivity list to get the desired D-Latch with Clr working.) Inputs and Outputs: entity Lab4b is Port ( Clr, Clk, D : in STD_LOGIC; Q : out STD_LOGIC); end Lab4b;

163


what is R Core Transformer. how it differs from normal transformers. dont search in net and post the answer.

733


what is 3.14 indicates for cutting length of stirrups

106


What causes sap to leak out of pine and maple trees?

932


why not taking cement at capital goods

453


what is diffrence between linear and binary search in array respect to operators?what kind of operator can be used in both seach methods?

656






Deloitte Informatica Interview Questions
  • Programming Languages AllOther (2)
  • ASP.NET (3)
  • Dot Net Framework (1)
  • Dot Net General (14)
  • Microsoft Related AllOther (1)
  • SQL Server (1)
  • SQL PLSQL (2)
  • Unix Commands (1)
  • QTP (11)
  • Manual Testing (11)
  • Mobile Testing (1)
  • Test Cases (1)
  • Testing AllOther (1)
  • COBOL (2)
  • JCL (1)
  • DB2 (2)
  • Core Java (1)
  • Servlets (1)
  • Teradata (2)
  • Business Objects (3)
  • Cognos (2)
  • Informatica (20)
  • Data Stage (1)
  • SAS (1)
  • Data Warehouse General (2)
  • HR Questions (1)
  • SAP ABAP (42)
  • SAP SD (23)
  • SAP PP (3)
  • SAP FI CO (11)
  • SAP Business Warehouse (1)
  • SAP Security (4)
  • SAP B1 (1)
  • Siebel (1)
  • Oracle Apps Technical (5)
  • Oracle Apps Financial (28)
  • Oracle Apps SCM (2)
  • Bio Informatics (1)
  • Mechanical Engineering (2)
  • Business Administration (1)
  • Banking Finance (5)
  • Human Resources (9)
  • Audit (6)
  • Taxation (7)
  • Accounting General (10)
  • Accounting AllOther (33)
  • Call Centre AllOther (3)
  • General Knowledge_Current Affairs (1)
  • Everything Else AllOther (6)
  • General Aptitude (5)
  • Placement Papers (3)
  • CISA Certification (1)
  • MAT (1)