Answer / vamsi

Encourage the person who is trying to give some answers,try
to learn the subject not the english.

Answer / versch

agree with Vamsi. the person who doesnt know you name know
better than you. Atleast he is answering the questions for
others benefit. Stop making such rekmarks. This panel is
for self-hel and helping others for interview.
Grt job Vamsi!! Keep up.

Answer / siva

If you set the source based commit, say 1000, it executes
commit after immediate of 1000 records read, irrespective
of how many rows passed to target (may be 600 since 400
dropped).

Similarly, if you set target based commit, say 1000, it
executes commit after immediate of 1000 records inserted,
irrespective of records read from source (may be 1500, rest
of 500 dropped)..

I think you got it..

Answer / srinu

source based commit,Target based commit
Both are Having the Same importence.
You can go for commit based on Importence,Requirement only.

If your source have limit then go for source based commit,
If your Target have limit then go for Target based commit.

Any ??? or Corrections,,let me know
‘Srinu.srinuvas@gmail.com ‘

Answer / infanewbee

i am new in Informatica ....................what does dropped means here(since 400 dropped/rest of 500 dropped) ??

Answer / krithi

Srinu,please learn how to write grammatically correct
english :-)

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

0 Answers   CTS,

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

How to update records in Target, without using Update Strategy?

3 Answers  

Explain the different kinds of facts.

0 Answers  

What is persistent lookup cache?

0 Answers  

What is the use of code page?

0 Answers  

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

Can we create two repositories on same database instance in oracle?

0 Answers  

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

What is the difference between Active and Passive transformation?

0 Answers   Informatica,