| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| supose if ur scr table contains alphanumeric values like
1,2,3,a,v,c in one columen like c1 n now u have load d data
in 2 seperare columns like ID should contain only numbers
1,2,3 n NAME col should contain a,b,cin target?How | Wipro | 3 |
| How many cubes create from a single model? | | 1 |
| 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 |
| What is power play plug in? | | 1 |
| What are the methods for creating reusable transforamtions? | | 2 |
| What is the status code? | | 1 |
| What is staging area? | | 5 |
| What is the capacity of power cube? | | 1 |
| If a session fails after loading of 10,000 records in to
the target.How can you load the records from 10001? | TCS | 4 |
| Transformer is a __________ stage
option1:Passive
2.Active
3.Dynamic
4.Static | Accenture | 1 |
| What is a command that used to run a batch? | | 2 |
| what is lookup ? | | 4 |
| how do u use sequence created in oracle in informatica?
Explain with an simple example | CTS | 2 |
| when we go for unconnected lookup transformation? and why? | Accenture | 3 |
| how can we load 365 flat file to a single fact table
(target) as a history load in single mapping? | | 1 |
| suppose a session is failed after a transformation , from
where that session will run again , i.e . from beginning or
from that transformation ? | TCS | 2 |
| whether Sequence generater T/r uses Caches? then what type
of Cache it is | Accenture | 3 |
| What is source qualifier transformation? | | 1 |
| need for registering a repository server | | 1 |
| S1 is having 1 lakh records and s2 is having 100 records,
s2 should compare s1 if emp no is same data should be
updated if not their it should insert the data.what are the
transformation used? | TCS | 1 |
| |
| For more Informatica Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
