Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Informatica Interview Questions
Questions Answers Views Company eMail

How to improve the session performance in informatica?

Accenture,

3 21524

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

1979

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

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 6379

what is curr val use for in sequence generator?

Emphasis,

2 7556

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 4859

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

Emphasis,

2 6316

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

Emphasis, JBL, Wipro,

2 10254

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 11839

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

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 9097

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 11043

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 9031

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

CTS, TCS,

1 6466

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

CTS, FEEE, TCS,

2365


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is fact table? Explain the different kinds of facts.

1076


What all join we can perform in LOOKUP transformation?

978


On which transformations you created partitions in your project?

1348


Explain the informatica workflow?

1070


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767


Where are the source flat files kept before running the session?

1078


What is sequence generator transformation in informatica?

1079


What is the status code in stored procedure transformation?

1182


Define pmcmd command?

1043


How to generate or load values in to the target table based on a column value using informatica etl tool.

1074


How do you change a non-reusable transformation to reusable transformation?

999


What are the new features of informatica 9.x in developer level?

998


How might you approve all mappings in the archive all the while?

1018


5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1910


How to do unit testing in informatica?

1172