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 6091

what is target update override and when we use it?

TCS,

2 5843

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

TCS,

5 9167

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 3989

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 3570

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 24554

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,

1672

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 15767

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

TCS,

2 7513

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

TCS,

7 8038

differences between service based and product based?

Satyam,

1557

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 5961

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

Zensar,

2 10445

why we use materialized view over view?

Zensar,

1 4457

can session assigned multiple mappings or not?

Zensar,

2 7058

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is informatica worklet?

597

What is meant by lookup transformation?

601

Whats there in global repository

1253

Tell me about MD5 functions in informatica

513

What are the performance considerations when working with aggregator transformation?

667




How to generate or load values in to the target table based on a column value using informatica etl tool.

602

How to load data in informatica ?

558

Differentiate between joiner and lookup transformation?

604

What is the maplet?

610

What is rank transformation in informatica

680

Define sessions in informatica etl?

609

How many number of sessions can one group in batches?

682

Did u used latest transformations of 8.6.0? for what?

1469

How to start a workflow using pmcmd command?

702

What is the advantage of informatica?

637

For More Un-Answered { Informatica } Questions Click Here