1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

please let me know which type of question arise in interview
on project manager round on insurance project with answer
pls reply asap.

Question Posted / kishore.soft2010


please let me know which type of question arise in interview on project manager round on insurance ..

Answer / hari

What is Mapping parameters and mapping variables?
when is $,$$,$$$ are used?
what is bad file and reject file?
How will you identify the missing records in target table?
what is the difference between Update as insert and Update else insert?
what type of indexes are used in your project?

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is aggregate awareness?

1 Answers  

tell me about your project functionality

0 Answers  

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

how to create a sample mapping for dynamic lookup transformation

2 Answers  




What are conformed dimensions?

1 Answers  

Differentiate between source qualifier and filter transformation?

0 Answers  

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

For more Informatica Interview Questions Click Here
Categories