| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How many repositories can we create in Informatica? | | 2 |
| What are the unsupported repository objects for a mapplet? | | 1 |
| What is data merging, data cleansing and sampling? | Satyam | 4 |
| in which situations do u go for starflake schema ? | TCS | 5 |
| What is the difference between OLTP and ODS? | | 2 |
| What are the data movement modes in informatcia? | | 2 |
| What is batch and describe about types of batches? | | 1 |
| what are the real time problems generally come up while
doing or running mapping or any transformation? | | 2 |
| what is the architecture of any Data warehousing project? | IBM | 4 |
| In mapping f.f as one src and f.f as trg,f.f as src and
oracle as trg which is fast? mean which is complete first
process | Wipro | 2 |
| i have flatfile source. i want to load the maximum salary of
each deptno into target. what isthe mapping flow | Wipro | 2 |
| What is a poling? | | 1 |
| we have table like cust_id,cust_name,cust_loc like this
1.we need to get perticular location,to do this we can use
filter transformatin,that logic is same for relation table
and flat file tabl? | | 2 |
| hi all, i have 1 flat file having 10 rows. like:-
id name amt
100 a 100
200 b 200
100 n 300
400 p 3000
100 a 100
600 x 6000
Now i want to load half of this data into one flat file and
remaining in other flat file.like :-
flat file 1
id name amt
100 a 100
200 b 200
100 n 300
----------------------
----------------------
flat file 2
id name amt
400 p 3000
100 a 100
600 x 6000
Plz reply me ASAP.
| | 8 |
| Hi All can anyone tell me where i will get Informatica
training in Mumbai? | | 1 |
| What is the difference between Normal load and Bulk load? | | 2 |
| What is the difference between Oracle performance and
Informatica Percfomance? Which performance is better? | IBM | 2 |
| what happens when a batch fails? | | 3 |
| I have 1200 records how can u send it in aggregator with
good performance issues? | | 2 |
| Explain about HLD and LLD ? | Accenture | 7 |
| |
| For more Informatica Interview Questions Click Here |