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 4690

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 10223

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 7279

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

 4 7479

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 6027

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

 4 6522

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

IBM,

1620

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 3527

what is mean by complex business rule ?

Cap Gemini,

1710

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

Wipro,

1 2772

why union is active transformation?

IBM,

4 6620

how to use incremental load?

TCS,

2 6777

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

iGate,

3 8595

what is incremental aggregation ,with example?

 2 7969

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

DELL,

8 11085

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is a connected transformation?

662

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1457

What is informatica powercenter repository?

700

Explain what are the different versions of informatica?

643

what is the size ur source like(file system or database)? how many record daily come u r banking project?

1738




Explain lookup transformation in informatica

636

Describe data concatenation?

560

how to load rows into fact table in data warehouse

627

what is SDLC way of code development?

1548

What is a rank transform?

664

What is the need for an etl tool?

625

How to create Target definition for flat files?

741

What does refresh system mean, and what are its distinctive choice?

558

How is union transformation utilized?

558

my source is junk data how will u remove that junk data by using unix please any one replay me

3227

For More Un-Answered { Informatica } Questions Click Here