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

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 7083

what are the types of Data warehousing ?

1 1569

what are the types of facts with Examples?

3 3628

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 6805

What are the tuning techniques you applied during your last project

1092

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 4551

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 5064

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

TCS,

4 11045

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,

4 8433

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 8347

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

2 4544

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

Wipro,

3 6540

Types of error logs in Informatica?

2 8982

expain about the tune parameters?

TCS,

1414

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,

1952


Post New Informatica Questions






Un-Answered Questions { Informatica }

What does “tail –f” command do and what is its use as an Informatica admin.

181


What are the differences between source qualifier and joiner transformation?

146


How to use procedural logic inside infromatica?

150


What is mapplet in informatica?

161


What is the use of target designer?

174






Explain the informatica workflow?

143


Differentiate between source qualifier and filter transformation?

172


What is a grid in Informatica?

163


How to create Target definition for flat files?

206


What are the components of workflow manager?

144


Is it possible to use a client with different version than that of its Informatica server?

179


What is dimensional table? Explain the different dimensions.

153


What are the static cache and dynamic cache in informatica?

158


While importing the relational source definition from the database, what are the metadata of source that will be imported?

286


The question was on time stamp. what is the difference between HH and HH24 when to use when.

992