| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the main data object present inbetween source and
target. I answered Mapping. Transformation etc.. But it is
not the answer. So please give me an apt answer. Thanks in
advance | Deloitte | 11 |
| What are the different types of schemas? | | 3 |
| What are the challenges of Dataware housing in the future? | HP | 1 |
| difference between stop and abort | | 2 |
| what is the difference between stop and abort? | TCS | 2 |
| what is the gap analysis? | | 1 |
| How to call stored Procedure from Workflow monitor in
Informatica 7.1 version? | Accenture | 1 |
| version controlling in informatica? | | 2 |
| How to display First letter of Names in Caps? | | 4 |
| What is batch and describe about types of batches? | | 1 |
| I've an excel sheet, in which one column contains data about
the location like "City, State" and few columns contains
only "State". Now I wanna load into my target City and State
into two different columns. Pls help me out... | | 5 |
| two types of data are there . one is mainframe and the other
is ascii format . in informatica how can you get both the
data in a single format in ascii . | TCS | 2 |
| Describe two levels in which update strategy transformation
sets? | | 1 |
| what are the different types of transformation available in
informatica and what are the mostly used ?
| | 1 |
| After dragging the ports of 3 sources
sqlserver,oracle,informix to single source qualiofier can
we map these ports directly to target and how? | | 2 |
| Hi Every One,What is Use of Factless Fact Table ?
Why we use Factless Fact Schema in the Projects
waiting for reply? thank you
| | 4 |
| hw to load this give the mapping?
cty state o/p
c1 s1 c1
c1 s2 s1
c1 s1 c1
c2 s3 s2
c3 s4 c1
c3 s2 s1
c2
s3
c3
s4
c3
s2
2 columns should be loaded to one column in target table? | Wipro | 1 |
| in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ? | Target | 8 |
| What is incremental aggregation and how it is done? | JPMorgan-Chase | 3 |
| How to write a procedure for a date which is in three
different formats,and you want to load into datawarehouse in
any single date formate | AHM | 1 |
| |
| For more Informatica Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
