Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

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

TCS,

3 4698

what is target update override and when we use it?

TCS,

2 4535

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

TCS,

5 6993

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 3074

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 2656

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 19551

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,

1218

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 13895

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

TCS,

2 6027

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

TCS,

7 6007

differences between service based and product based?

Satyam,

1123

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 4491

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

Zensar,

2 9227

why we use materialized view over view?

Zensar,

1 3486

can session assigned multiple mappings or not?

Zensar,

2 5887


Post New Informatica Questions






Un-Answered Questions { Informatica }

How can informatica be used for an organization?

154


Which development components of informatica have the highest usage?

172


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

9646


what is Active lock explain

1905


h0w many versions have been developed of onformatica so far?

1260






Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

1729


What do think which one is the better joiner or look up?

174


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

203


What is a joiner transformation?

141


What are the components of the workflow manager?

151


What are the components of workflow manager?

144


How does a sorter cache works?

171


What is the need of an ETL tool?

186


is it possible to index the data in cache of lkp transformation ?

1083


Explain the features of connected and unconnected lookup.

135