| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 | 3 |
| WAT IS THE MEANING OF UPGRADTION OF REPOSITORY? | Wipro | 1 |
| how can u tune u r informatica mapppings | CTS | 2 |
| what is update strategy transformation ? | | 3 |
| sir presently i am persuing my m.tech
recently i got job in tcs as fresher presently iam doing my
9 months project related to informatica can any one guide
me how to create fact tables what type of schemas must be
used and so on if so give ur mail ids so that i can contct
through it | | 1 |
| What are the different types of Type2 dimension maping? | | 1 |
| How many number of sessions that u can create in a batch? | | 3 |
| In a mapping i have three dimensions. If i want to pass a
same surrogate key value to all the three dimensions by
using one sequence generator is possible?If the mapping is
containing single flow? And in the same case if the mapping
is contaning 3 flows for the three dimensions then by using
one sequence generator can we populate surrogate key (same
value) to all the three dimensions? | | 6 |
| what is lookup ? | | 5 |
| how to join the two flatfiles using the joiner t/r if there
is no matching port? | Cegedim | 4 |
| What is A cache? | | 1 |
| How to view and Generate Metadata Reports? | | 1 |
| 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 Friends,
I want lo truncate my records from target before loading
current month data,but i dont have permission to truncate
with truncate option
if u know any other way please give your valuable input for
this.
Thanks
Abhishek | CSC | 4 |
| Without source how to insert record to target? | | 4 |
| how do u get the first record from 50,000 records ? | TCS | 7 |
| Where is the cache stored in informatica?
| Infosys | 4 |
| what is the gap analysis? | | 1 |
| suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how | TCS | 4 |
| What is the use of incremental aggregation? | | 2 |
| |
| For more Informatica Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
