| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 1:when we develop a project what are the performance issue
will raise?? KPIT
2:if a table have INDEX and CONSTRAINT why it raise the
performance issue bcoz when we drop the index and disable
the constraint it performed better??KPIT
3:what are unix commands frequently used in informatica??
| KPIT | 1 |
| How can we eliminate duplicate rows from flatfile,explain? | | 3 |
| Flat file heaving 1 lack records and I want to push 52000
records to the target? | | 6 |
| 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 |
| what is the difference between Informatica7.1 & informatica
8.1 | | 2 |
| If i done any modifications for my table in back end does it
reflect in informatca warehouse or maping desginer or source
analyzer? | | 2 |
| HOW DO YOU PARFORM INCREMENTAL LAOD ? | SAIC | 4 |
| How to find from a source which has 10,000 records, find the
average between 500th to 600th record? | | 1 |
| What are the Differences between connected and unconnected
lookup? | | 1 |
| How to import oracle sequence into Informatica? | Satyam | 3 |
| I have a condition sal=100 and I created one router and in
that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100,
first which condition will satisfy, and Why? | | 8 |
| what is a transforamation? | | 3 |
| what is a junk dimension ? | TCS | 5 |
| how do u tune queries? | | 1 |
| wat s mapping parameter and mapping variable? how do you
set that in a mapping? | | 2 |
| How do you create single lookup transformation using
multiple tables? | TCS | 5 |
| THREE DATE FORMATS R THERE . HOW TO CHANGE THESE THREE INTO
ONE FORMAT WITHOUT USING EXPRESSION TRANSFORMATION ? | HP | 2 |
| how to work with mapplet designer in informatica? | | 4 |
| how to declare array in plsql? | | 1 |
| How do we come to know the Source data/file is
ready/Updated in the source location, when the session is
scheduled for @12:00AM and ready to run its job ? or Can we
schedule the session, when the source is updated in source
location without any time constraint? | iFlex | 1 |
| |
| For more Informatica Interview Questions Click Here |
Site Map
