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 19450

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

1381

,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 6265

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 4992

what is curr val use for in sequence generator?

Emphasis,

2 5904

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 3712

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

Emphasis,

2 4794

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

Emphasis, JBL, Wipro,

2 8735

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 9145

-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 4642

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 7230

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 7892

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 7818

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

CTS, TCS,

1 5483

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

CTS, FEEE, TCS,

1749


Post New Informatica Questions

Un-Answered Questions { Informatica }

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10065


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

513


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

487


What is union transformation?

422


What do think which one is the better joiner or look up?

485






What is sorter transformation?

416


What is intricate mapping?

419


Do you find any difficulty while working with flat files as source and target?

475


How to do the error handling of if ur source is flatfiles?

1340


how to load rows into fact table in data warehouse

490


Describe data concatenation?

390


How to load data in informatica ?

401


Briefly describe lookup transformation?

451


What is the difference between a repository server and a powerhouse?

499


Please let me know how to make Data masking in informatica..

1098