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

Informatica Interview Questions

Questions Answers Views Company eMail

how we can update a target table without update strategy and update override?

TCS,

3 7388

what is target update override and when we use it?

TCS,

2 6793

select count(1) from emp? what is the o/p?

TCS,

5 10671

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

IBM,

1 4762

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

Infosys, Saksoft,

1 4365

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

IBM, Patni, TCS,

3 26000

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

Infotech,

2077

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

CompuSoft, EDS, TCS,

4 17144

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

TCS,

2 8500

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

TCS,

7 9944

differences between service based and product based?

Satyam,

1979

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

Satyam,

3 7116

Can we insert ,update ,delete in target tables with one update strategy tran.?

Zensar,

2 11348

why we use materialized view over view?

Zensar,

1 5214

can session assigned multiple mappings or not?

Zensar,

2 8028

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is substr in informatica?

1148

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

1044

Explain how to import oracle sequence into informatica?

968

What is workflow manager?

1003

2077

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1928

What are the differences between oltp and olap?

934

Define update strategy?

1136

What is resilience time?

1065

What is the use of source qualifier?

1086

Why do you use Mapping Parameter and mapping variable?

1705

What is fact table? Explain the different kinds of facts.

1027

list out all the transformations which use cache?

1131

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1459

What is the scenario which compels informatica server to reject files?

1024

For More Un-Answered { Informatica } Questions Click Here