| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to delete duplicate records in a flat file source? | | 1 |
| what is the logic will you implement to laod the data in to
one factv from 'n' number of dimension?
| | 1 |
| what is the diff b/w target load plan and cbl? | | 1 |
| in which situations do u go for starflake schema ? | TCS | 5 |
| what is worklet and what use of worklet and in which
situation we can use it? | | 2 |
| what is update strategy transformation ? | | 3 |
| we have a parameter file in Unix location where we
have .txt files and those file will be used as source in
informatica.
I cannot use source file name directly as file name will
keep on changing in unix location.
I need to define $$InputFile as parameter.
Can anybody send me the parameter file and the steps to
handle this.
| TCS | 2 |
| what is surrogatekey ? In ur project in which situation u
has used ? explain with example ? | | 4 |
| What are the joiner caches? | | 2 |
| IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ? | HP | 4 |
| What are the connected or unconnected transforamations? | | 2 |
| After draging the ports of three sources(sql
server,oracle,informix) to a single source qualifier, can
you map these three ports directly to target? | | 4 |
| What is the difference between Normal load and Bulk load? | | 2 |
| What is operational data source (ODS)? | | 2 |
| What is the functionality of update strategy? | | 1 |
| Can you start a session inside a batch individually? | | 1 |
| i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow | Wipro | 2 |
| in unconnected lookup , what are the other transformations ,
that can be used in place of that expression transformation ? | Target | 8 |
| What are the types of metadata that stores in repository? | | 1 |
| What is polling? | | 1 |
| |
| For more Informatica Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
