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

without dynamic lookup how to insert new rows and update existing rows?

HP,

1 4717

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

iNautix,

8 10315

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

Fidelity,

4 7327

Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks

 4 7528

What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

 4 6077

Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?

 4 6573

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

IBM,

1642

Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks

IBM,

1 3556

what is mean by complex business rule ?

Cap Gemini,

1723

In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

Wipro,

1 2815

why union is active transformation?

IBM,

4 6685

how to use incremental load?

TCS,

2 6857

My source table having some records ,i want load 1st record and last record into one target?

iGate,

3 8634

what is incremental aggregation ,with example?

 2 8012

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

DELL,

8 11163

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to elaborate powercenter integration service?

654

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7772

Difference between Data and Index Caches?

662

What do you mean by blocking transformation?

589




Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1657

What are the transformations that are not supported in mapplet?

604

Define mapping and session?

587

Why sorter is an active transformation?

758

Explain what are the different versions of informatica?

660

What is a dimensional model?

585

What is rank transformation in informatica

693

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

645

How to convert multiple rows to single row (multiple columns) in informatica

901

can anyone suggest best free Talend data integration training online

1264

For More Un-Answered { Informatica } Questions Click Here