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

How to improve the session performance in informatica?

Accenture,

3 18774

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1158

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

Emphasis,

3 5679

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

Emphasis,

2 4410

what is curr val use for in sequence generator?

Emphasis,

2 5346

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

Emphasis,

1 3304

what is the necessity to use update strategy?(except for updates)

Emphasis,

2 4348

What is the method of seperating unique and duplicate records in session level?

Emphasis, JBL, Wipro,

2 8089

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

Accenture,

6 8105

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

TCS,

1 4163

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

Satyam,

3 6562

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

iGate,

7 6753

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 7271

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

CTS, TCS,

1 5173

What are the issues you have faced in your project? How did you overcome those issues?

CTS, FEEE, TCS,

1520


Post New Informatica Questions






Un-Answered Questions { Informatica }

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

7732


Explain target update override in informatica

249


What does reusable transformation mean?

267


How to load a Dimension ? and how to load a fact table?

558


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1114






What is the use of transformation?

238


Can we get 1st record through Informatica(without sequence number).

531


What is enterprise data warehousing?

220


How to load data in informatica ?

219


What is primary and backup node?

275


What is Data Caches size?

261


State the differences between sql override and lookup override?

203


What is depict expression change?

224


How can we improve session performance in aggregator transformation?

286


What you know about transaction control transformation?

221