| Other Informatica Interview Questions |
|| Asked @
|i have a table like
empid ename year month sal
1 x 98 jan 500
1 x 98 feb 500
1 x 98 mar 500
1 x 99 jan 600
1 x 99 feb 600
2 y 98 jan 600
2 y 98 feb 600
2 y 98 mar 600
2 y 99 jan 700
2 y 99 jan 700
and so on
i want to find out totsal for every emp on year wise
plz help me
|Hi I have two sources like A, B. My source A contain 10000
million records from that i need 20 attributes. My source B
has also same 10000 million records from that i need only 1
attribute. By using Joiner i have to load into target? Is
there any issue regarding this? if issue is there how to
tune this mapping in best way?
What is BULK mode and NORMAL mode, Which one gives better
performance. How? Please Explain with an example...! It
will help's me a lot.
Thanks In advance.
|How to Explain My project flow,In TCS ased me this question.
In which way i can start my project flow and they asked how
many fact tables and dimensional tables u used. Can any one
Explain Briefly for this question and project architecture
|What are the types of maping wizards that r to be provided
|8.what is mapplet ?give example?
|SRC1 -> EXP -> AGGR ->
SRC2 -> EXP ->
Above is a maaping with two pipeline connected to the taret
TGT. Design wise is this design is correct or not ?
|i have two tables,table 1 having 2 columns and 3
rows,table2 having 3 columns and 2 rows.what is the output
if i do left outerjoin,full outer join,right outer join?
|What is query panel?
|Work flow failed when it is set to Bulk mode but it was
when set to normal mode y??(All the connections are fine and
|I have source like col1,col2,col3,col4 and the values are like
i want the output like
How we will achieve in this scenario in informatica level.
Please help me..
Thanks in advance..
|explain about informatica server architecture?
|For more Informatica Interview Questions Click Here |