Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Informatica Interview Questions
Questions Answers Views Company eMail

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

TCS,

2 7301

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

CTS,

4129

can we use cartesian join in informatica

IBM,

3 8435

why we use informatica in our project?

TCS,

2 7287

what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 6891

can we use self join in informaitca?

IBM,

3 19318

what is bitmap index? did u use it?and how to use it in informatica

IBM,

1 3040

what is degenerated dimension?

IBM,

1 3872

what is constraint based loading

IBM,

2 6396

which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?

IBM,

6 10440

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

IBM, Polaris,

2 6425

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

Zensar,

2 6909

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

Emphasis,

6 9698

Can anyone please distinguish what is Inner join and Outer join

Wipro,

2 6151

What is the exact difference b/w IN and EXIST in Oracle..?

Wipro,

4 9067


Post New Informatica Questions

Un-Answered Questions { Informatica }

Where do we use mapping variables in informatica?

996


What's the layout of parameter file (what does a parameter file contain?)?

2334


What are pre and post-session shell commands?

1236


Differentiate between source qualifier and filter transformation?

1508


Parameter and variable differences

2005


EXL informatica Questions

1310


On which transformations you created partitions in your project?

1249


What are roles and groups and benefits of using them?

989


While migrating the data from one environment to another environment how would you manage the connections?

1046


If informatica has its scheduler why using third party scheduler?

1193


What is the cumulative sum and moving sum?

1135


Plz can any one say me how to get the informatica certification materials and dumps

1998


What is difference between a gateway node and worker node?

1064


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1893


server hot-ws270 is connect to Repository B. What does it mean?

2439