Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

TCS, Wipro,

4 15044

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

CTS,

6 20433

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

CTS,

4 11042

can v update d records in target using update stargey without generationg primary key ? explain

CTS,

4 16881

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

Wipro,

1 7578

hw cn v elimate dublicate values from lookup without overriding sql?

CTS,

7 17790

difference between stop and abort

2 10090

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 8311

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

Wipro,

2 7475

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 16383

when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

Cegedim, IBM, TCS,

7 17421

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 5506

how to duplicates from expression transformation without using sorter before that

1 14946

How many repositories can we create in Informatica??

IBM, Patni,

9 33537

What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .

1 4462

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is meant by LDAP users?

1209

Explain what is informatica metadata and where is it stored?

1049

Differentiate between Load Manager and DTM?

2153

Parameter and variable differences

2062

How can repository reports be accessed without sql or other transformations?

1219

Explain load alternative records / rows into multiple targets - informatica

1152

What is union transformation?

965

What is dimensional table?

1062

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1664

Differences between connected and unconnected lookup?

1218

Plz can any one say me how to get the informatica certification materials and dumps

2048

What is intricate mapping?

1203

What is informatica? Why do we need it?

1097

Which development components of informatica have the highest usage?

1043

r u done any partitions in ur project?

1827

For More Un-Answered { Informatica } Questions Click Here