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 9676

what are the types of Data warehousing ?

1 2970

what are the types of facts with Examples?

3 5880

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 9124

What are the tuning techniques you applied during your last project

1981

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 7593

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 7661

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

TCS,

4 13875

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 13055

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 11765

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

2 6151

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

Wipro,

3 8877

Types of error logs in Informatica?

2 11889

expain about the tune parameters?

TCS,

2350

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 2911


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the different ways to implement parallel processing in informatica?

1358


In how many ways we can create ports?

1080


What is the function of aggregator transformation?

1031


what is Active lock explain

2736


Describe an informatica powercenter?

1053


Enlist few areas or real-time situations where informatica is required.

1038


Explain dynamic target flat file name generation in informatica

1020


Explain the different kinds of facts.

943


Explain the pipeline partition with real time example?

1094


What are junk dimensions?

1033


What is a dimensional model?

942


How do you use reject loader.

2555


Where do we use mapping variables in informatica?

1008


How many dimensions are there in informatica?

1036


What all join we can perform in LOOKUP transformation?

929