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

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

Cap Gemini,

3 9832

what are the types of Data warehousing ?

1 3055

what are the types of facts with Examples?

3 6004

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

HP,

3 9262

What are the tuning techniques you applied during your last project

2024

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 7731

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

HP,

3 7813

How we will implement Pushdown Optimization and Types in Informatica with better examples

TCS,

4 14026

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

Cap Gemini,

5 13240

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

Cap Gemini,

5 11941

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 6260

can we have to do changes in session property when we are dynamically generating target files?

Wipro,

3 9017

Types of error logs in Informatica?

2 12045

expain about the tune parameters?

TCS,

2414

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

IBM,

1 2999


Post New Informatica Questions

Un-Answered Questions { Informatica }

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1580


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

1200


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4109


What differs when we choose the sorted input for aggregator transformation?

1021


where to store informatica rejected data?

1093


Difference between Target-based loading and constraint-based loading?

998


What is different between the data warehouse and data mart?

1063


What is a node in Informatica?

1041


Write the advantages of partitioning a session?

1282


What are the types of schemas we have in data warehouse.

961


What are the types of presistent cache in look up tr.

2055


What is a predefined event?

1093


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2026


update strategy transformation in informatica

1064


have u done any performance tuning? how u ll do?

2299