Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

609

EXL informatica Questions

522

Major difference between SQL override and Lookup Sql override

1 926

What are the reusable transformations?

Informatica,

249

What is the maplet?

Informatica,

229

Explain incremental aggregation in informatica

Informatica,

236

How to generate sequence numbers without using the sequence generator transformation?

Informatica,

223

What is rank transformation in informatica

Informatica,

254

How to improve the performance of a session using sorter transformation?

Informatica,

262

How to generate sequence numbers using expression transformation?

Informatica,

225

What is Index Caches size?

Informatica,

217

What is Session and Batches?

Informatica,

221

Explian the connected and unconnected lookup transformation

Informatica,

234

What is the Rank index port in Rank transformation?

Informatica,

237

What are mapplets? How is it different from a Reusable Transformation?

Informatica,

241


Post New Informatica Questions






Un-Answered Questions { Informatica }

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

1530


Which development components of informatica have the highest usage?

215


can we override a native sql query within informatica? Where do we do it?

193


How we can confirm all mappings in the repository simultaneously?

195


How do you load only null records into target?

192






Which files are created during the session rums by informatics server?

215


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1128


Is there any way to read the ms excel datas directly into informatica?

199


What are pre and post-session shell commands?

210


What is a grid in Informatica?

223


What are the components of the workflow manager?

204


Explain pushdown optimization and types in informatica

233


What is the advantage of informatica?

192


What is a dimensional model?

211


How can we use mapping variables in informatica? Where do we use them?

187