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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
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

For More Un-Answered { Informatica } Questions Click Here