1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

How to improve the session performance in informatica?

Accenture,

3 20055

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

 1546

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

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 5345

what is curr val use for in sequence generator?

Emphasis,

2 6360

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 4010

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

Emphasis,

2 5136

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

Emphasis, JBL, Wipro,

2 9167

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 9871

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

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 7825

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 8889

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 8167

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

CTS, TCS,

1 5776

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

CTS, FEEE, TCS,

1903

Post New Informatica Questions

Un-Answered Questions { Informatica }

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1192

How will the document be delivered to me?

609

What is the Rank index port in Rank transformation?

663

Informatica settings are available in which file?

579

How to load last n records of file into target table - informatica

588




Explain target update override in informatica

622

what is SDLC way of code development?

1548

What is the difference between stop and abort in informatica

652

What is the difference between router and filter?

636

what is diff b/t sorter t/r and agg have the option sorter property...

1730

What is the need of etl tools?

594

What is the advantage of informatica?

636

What are the settings that you use to configure the joiner transformation?

604

Suppose we do not group by on any ports of the aggregator what will be the output?

561

What are connected or unconnected transformations?

617

For More Un-Answered { Informatica } Questions Click Here