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

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

Zensar,

1 6357

How you count the number of records available at your source?

Zensar,

3 12984

How you load distinct records into one target and duplicate records into another target?

Mphasis,

3 15004

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

HP,

5 9667

write a query to get maximum salary from the employers table without duplicates....kindly help me

CTS,

5 8531

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

TCS,

3 6081

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

HP,

3 7649

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

Qwest,

1 5242

Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.

CTS,

2 13013

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

CTS,

8 12376

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

Cap Gemini,

11 28590

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

TCS,

3 5261

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

Keane India Ltd,

5 7487

What are the different caches used in informatica?

UST,

3 6050

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

Hexaware,

1 5713

Post New Informatica Questions

Un-Answered Questions { Informatica }

How does the aggregator transformation handle null values?

685

Explain scd type 3 through mapping.

567

Did u used latest transformations of 8.6.0? for what?

1464

In warehouses how many schemas are there?

570

What is the benefit of partitioning a session?

612




What is the function of aggregator transformation?

566

State the limitations where we cannot use joiner in the mapping pipeline?

536

Where can we find the throughput option in informatica?

590

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

774

differences between service based and product based?

1550

What is different between the data warehouse and data mart?

619

list out all the transformations which use cache?

676

What are the reusable transformations?

684

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1736

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

591

For More Un-Answered { Informatica } Questions Click Here