| Other Informatica Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to duplicates from expression transformation without
using sorter before that | | 1 |
| if i have records like these
(source table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
10001 gfhgdgh
10002 hjkdghkfh
the target table should be like these by using expression
tranformation.
(Target table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
xx001 gfhgdgh
xx002 hjkdghkfh
(that means duplicated records should contain XX in there
rowid)
| iFlex | 4 |
| 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 |
| what is a time dimension? give an example? | | 2 |
| Explain about perform recovery?
| | 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 | 3 |
| How do you take care of security using a repository manager | | 2 |
| What will happen when Mapping variable and Mapping parameter
is not defined or given?
Where do you use mapping variable and mapping parameter? | Deloitte | 8 |
| What is difference between a connected look up and
unconnected look up? | | 3 |
| How to load time dimension? | Ford | 1 |
| Router T/R is active but some people are saying it is also
passive which is exactly right? | | 4 |
| What is status code? | | 1 |
| how to calculate the optimum cache size in aggregator
transformation? | | 1 |
| how many tasks are there in informatica ?
| TCS | 3 |
| Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table. | | 1 |
| Could any one to tell Fact table Partitioning? | | 1 |
| Can you start a session inside a batch individually? | | 1 |
| how will you remove the duplicate records from flat file
without using sorter? | | 2 |
| What are the basic needs to join two sources in a source
qualifier? | | 4 |
| What is data quality? How can a data quality solution be
implemented into my informatica transformations, even
internationally? | Wipro | 1 |
| |
| 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
