1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

wht is cdc?how to use it in creation of mappings?

HSBC,

6 20552

wht target override?wht advantages it has compare to target update?

Polaris,

2 12810

how to calculate the optimum cache size in aggregator transformation?

 1 7106

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

Alcatel-Lucent, ECI Telecom,

3 7555

What is the difference between Bitmap and Btree index?

Mind Tree,

3 18657

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 7892

How to delete duplicate record in Informatica?

 7 28205

What is the difference between view and materialised view?

 6 12473

Hi All can anyone tell me where i will get Informatica training in Mumbai?

 3 5803

how many types transformations supported by sortedinput?

 4 7051

what is lookupoverriding?

1 4696

what is the process of target load planing?

IBM,

2 5614

what is the process we used in joiner transformation,there is no matching column in sources?

 2 5880

what is the diff b/w union and joiner and lookup?

 4 12645

how can u load the data in time dimension?

 3 10485

Post New Informatica Questions

Un-Answered Questions { Informatica }

generate date / time dimension in informatica

705

Design a mapping to load a target table with the following values from the above source?

861

How is union transformation utilized?

554

difference between informatica 8.1.1 and 8.6

3229

what is the size of your data warehousing?

1657




What are Dimensional table?

597

What is domain and gateway node?

683

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6051

Explain where to store informatica rejected data? How to extract the informatica rejected data?

567

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

769

What are the types of caches in lookup?

556

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1224

What do you mean by blocking transformation?

569

Explain sessions. Explain how batches are used to combine executions?

581

Describe data concatenation?

558

For More Un-Answered { Informatica } Questions Click Here