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

Informatica Interview Questions
Questions Answers Views Company eMail

in static and dynamic which one is better

2 3284

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 6866

what is dynamic cashe


3 4479

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 13183

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

Cap Gemini, Wipro,

10 12319

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

2 4183

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

3 3961

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

Cap Gemini,

2 6965

what is flat file override?

Cap Gemini, HP,

1 8689

what is mapping override?

Cap Gemini,

2 5879

what is session override?

Cap Gemini,

2 9341

what is parameter file?

Cap Gemini,

1 4179

what is mapping parameter?

Cap Gemini,

2 4622

what is session parameters?

Cap Gemini,

1 4781

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

Cap Gemini,

4 7750

Post New Informatica Questions

Un-Answered Questions { Informatica }

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?


what are factless facts? And in which scenario will you use such kinds of fact tables.


In which transformation you cannot drag ports into it?


In informatics server which files are created during the session rums?


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?


Explain about cumulative Sum or moving sum?


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?


Explain the shared cache and re-cache?


What is native users?


Briefly describe lookup transformation?


What are the databases that informatica can connect to windows?


Plz can any one say me how to get the informatica certification materials and dumps


What is a sequence generator transformation?


How can you validate all mappings in the repository simultaneously?


What is meant by incremental aggregation?