| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Why touse stored procedure in ETL Application?
| | 1 |
| Why do we use DSS database for OLAP tools? | | 1 |
| What is aggregate cache in aggregator transforamtion?
| | 2 |
| In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure? | | 2 |
| when we go for unconnected lookup transformation? and why? | Accenture | 3 |
| two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ? | HP | 6 |
| what we require for D.modelling? | | 1 |
| what transformations are used for Variable port?
| | 1 |
| what is surrogatekey ? In ur project in which situation u
has used ? explain with example ? | | 4 |
| How can yoU create or import flat file definition in to the
warehouse designer? | | 1 |
| How will u find weather dimension table is big in size of a
fact table? | | 1 |
| wt is informatica file watch timers
in aflat i want to get the first record and last record how
could i. | CTS | 1 |
| How to load a relational source into file taget? | | 1 |
| What is the difference between Normal load and Bulk load? | | 2 |
| If you want to create indexes after the load process which
transformation you choose? | HCL | 2 |
| what is the logic will you implement to load data into a
fact table from n dimension tables? | TCS | 2 |
| How do you handle decimal places while importing a flatfile
into informatica? | | 1 |
| how to run 2 workflows sequentially. plz respond what is the
process? | Cap-Gemini | 2 |
| i have f;latfile source. i have two targets t1,t2. i want to
load the odd no.of records into t1 and even no.of recordds
into t2. what is the procedure and whar t/r's are involved
and what is the mapping flow | Wipro | 4 |
| When do we use dynamic cache and static cache in connected
and unconnected lookup transformations? | | 2 |
| |
| For more Informatica Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map