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 13387

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

CTS,

6 18113

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 9370

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

CTS,

4 15339

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 6658

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

CTS,

7 15499

difference between stop and abort

2 9173

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 7000

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 6316

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 13056

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 14836

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 4486

how to duplicates from expression transformation without using sorter before that

1 14258

How many repositories can we create in Informatica??

IBM, Patni,

9 30333

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 3744


Post New Informatica Questions

Un-Answered Questions { Informatica }

Why sorter is an active transformation?

724


What are the advantages of informatica?

550


Write the unconnected lookup syntax and how to return more than one column.

568


How to update or delete the rows in a target, which do not have key fields?

629


What do you understand by SOA of Informatica?

568






Can we create two repositories on same database instance in oracle?

588


What is target load order?

775


How to configure mapping in informatica?

650


How do you migrate data from one environment to another?

622


What is the advantage of informatica?

624


What is meant by pre and post session shell command?

600


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1848


What is the use of target designer?

581


Explain what are the different versions of informatica?

627


Is it possible to revert a global repository to local one and why?

591