Informatica Interview Questions
Questions Answers Views Company eMail

in static and dynamic which one is better

2 4204

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 8534

what is dynamic cashe

Informatica,

3 5768

Hi, I have one scenario.. i want to insert 4 times (Duplicate) a row in the target. Please help me . source row: abcabc Tgt table: abcabc abcabc abcabc abcabc

Cap Gemini, IBM,

10 16897

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

Cap Gemini, Wipro,

10 15976

how to improve performence by using sorted input in aggrigator t/r.

2 5104

empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.

3 5136

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

Cap Gemini,

2 8760

what is flat file override?

Cap Gemini, HP,

1 10306

what is mapping override?

Cap Gemini,

2 7573

what is session override?

Cap Gemini,

2 10874

what is parameter file?

Cap Gemini,

1 5509

what is mapping parameter?

Cap Gemini,

2 6028

what is session parameters?

Cap Gemini,

1 5990

1 lac of flat fles in source how to load target at a time?

Cap Gemini,

4 9800


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are ETL Tools?

647


How to update source definition?

607


Explain the scenario which compels informatica server to reject files?

627


What is meant by incremental aggregation?

558


What is the difference between stop and abort in informatica

633






Sequence generator, when you move from develoment to production how will you reset

1375


Define enterprise data warehousing?

612


What do you mean incremental aggregation?

604


What is the function of look up transformation?

623


In which transformation you cannot drag ports into it?

759


How does a rank transform differ from aggregator transform functions max and min?

640


What if the source is a flat-file?

568


What are the modules in Power Center

1201


Does an informatica transformation support only aggregate expressions?

577


How many ways are there to create ports?

686