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 7536

what is target update override and when we use it?

TCS,

2 6918

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

TCS,

5 10876

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 4848

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 4438

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 26141

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,

2131

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 17299

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

TCS,

2 8613

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

TCS,

7 10179

differences between service based and product based?

Satyam,

2014

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 7239

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

Zensar,

2 11442

why we use materialized view over view?

Zensar,

1 5303

can session assigned multiple mappings or not?

Zensar,

2 8146

Post New Informatica Questions

Un-Answered Questions { Informatica }

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1091

tell me the rules and responsblites in our project(my project is development)

1933

How does a sorter cache works?

1069

What will be the approach?

979

Tell me about MD5 functions in informatica

929

What is native users?

1162

What is dimensional table?

1062

Describe the impact of several join conditions and join order in a joiner transformation?

1063

What is a code page?

1177

Explain lookup transformation in informatica

1073

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128

What are the different types of olap? Give an example?

1057

Why filter transformation is an active one?

987

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

2340

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1160

For More Un-Answered { Informatica } Questions Click Here