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 5844

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

TCS,

5 9168

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 24555

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 7514

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 5962

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 4458

can session assigned multiple mappings or not?

Zensar,

2 7058

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the designer tools for creating transformations?

670

Explian the Process of deployment groups in informatica

646

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1547

What can we do to improve the performance of informatica aggregator transformation?

608

What does “tail –f” command do and what is its use as an Informatica admin.

622




HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1467

What is status code in informatica?

570

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

624

What is meant by active and passive transformation?

576

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1685

What are data-driven sessions?

708

How to extract the informatica rejected data?

739

What is an Integration service in Informatica?

694

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1497

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

1739

For More Un-Answered { Informatica } Questions Click Here