201. What is Dataware house key?

202. How do we delete staging area in our project?

203. How to do aggregation with out using AGGREGAROR Transformation ?

204. 1)What are the various test procedures used to check whether the data is loaded in the back end, performance of the mapping, and quality of the data loaded in INFORMATICA.2) What are the common problems developers face while ETL development

205. how do we remove the staging area

206. What are the types of loading in Informatica?

207. In my source table 1000 rec's are there. I want to load 501 rec to 1000 rec into my Target table ?

208. how can we eliminate source bottleneck using query hint

209. when informatica 7.1.1 version was introduced into market

210. How to partition the Session?(Interview question of CTS)

211. How do you change change column to row in Informatica

212. How do we lookup data in the target and the source to compare them without using lookup transformation? basically i mean getting lookup functionality without using lookup transformation?thank you


213. We can insert or update the rows without using the update strategy. Then what is the necessity of the update strategy?

214. How a LOOKUP is passive?

215. Hello,I was asked this question in an interview,Where did you implement SCD2 and what was the transformations used.What was the complex transformations did you use.Answers please........

216. Hi ,About Informatica Power center 7:1) I want to Know which mapping properties can be overridden on a Session Task level.2)Know what types of permissions are needed to run and schedule Work flows.Someone can help me?Thank you.

217. write a query to retrieve the latest records from the table sorted by version(scd).

218. what s an ODS? what s the purpose of ODS?s that a logical database that stores extracted data from source ?

219. Is it possible to execute work flows in different repositories at the same time using the same informatica server?

220. Explain about scheduling real time in informatica

221. What are the Differences between Informatica Power Center versions 6.2 and 7.1, also between Versions 6.2 and 5.1?

222. hii. this question was asked in accenture interviewIf ur having source table in which there are records of 10 different countries and ur havig 10 target tables so tell me how should we load the individual data of country in individual table.i know that we can do this using router transformation but i m not able to make it so plz can anyone help me in this.regardsTarang Jain

223. How Can we join one relational table and one flat file without having common key using joiner transoformation? Is it possible to join without common key to join using joiner transformation?

224. how can we remove/optmize source bottlenecks using "query hints"

225. what is the advantages of converting stored procedures into Informatica mappings?

226. hi, how we validate all the mappings in the repository at once

227. How to use incremental aggregation in real time?
228. How many staging areas are there in your project? Recently I have asked this question is there number of staging areas? Please briefly explain it , Thanks in advance.

229. What are Target Options on the Servers?
Target Options for File Target type are FTP File, Loader and MQ.There are no target options for ERP target typeTarget Options for Relational are Insert, Update (as Update), Update (as Insert), Update

230. what is sql override where do we use and which transformations

231. what is constraint based error? how ll u clarify it?

232. How do you import 500file from tally software in informatica. ?

233. Which transformation has the most complexity Lookup or Joiner?

234. What's the difference between source and target object definitions in Informatica?

235. What are variable ports and list two situations when they can be used?

236. What are all the new features of informatica 8.1?

237. How to FTP a file to a remote server?

238. how do u check the source for the latest records that are to be loaded into the target.i.e i have loaded some records yesterday, today again the file has been populated with some more records today, so how do i find the records populated today.
239. What is the purpose of using UNIX commands in informatica. Which UNIX commands are generally used w
What is the purpose of using UNIX commands in informatica. Which UNIX commands are generally used with informatica.

240. what is the difff between static cache and dynamic cache in which scenario do we use them .give the
241. Kindly suggest how to install and configure Informatica in Unix. I have installed informatica in Windows 2000 can I use the same CDs to install in unix ..

242. which one is better performance wise joiner or lookup

243. hi... this was asked in acccenture interview can anyone plz tell me the answerwhat is the difference between informatica 7.1 and 8.1

244. what is the logic will you implement to load the data in to one fact from 'n' number of dimension tables.

245. What is meant by source is changing incrementally? explain with example

246. how can we delete duplicate rows from flat files ?

247. How to load the time dimension using Informatica ?

248. What can we do in mapplets,that we cannot do in mappings

249 1. While executing an FTP command in a Shell script, we get following error : TM_6056 Error executing shell command [FILE_TRANSFER.sh]. Return code is [256].
2. From experience we know that this is due to FTP failure. Resolution is to first resolve the FTP error & then re-start the workflow/server.
3. I want to know what is the method of getting more details & resolution for such "Return Codes" (256 or any other) ?

250. Explain the pipeline partition with real time example?