What is the sql query overwrite in source qualifier in informatica


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

how can i invoke pmcmd in command line prompt

1 Answers  


Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  


What is a filter transformation and why it is an active one?

0 Answers  


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,


A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  






How can you define user defied event?

0 Answers  


Explian the connected and unconnected lookup transformation

1 Answers   Informatica,


what is filelist concept in informatica

4 Answers  


What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,


I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,


What is olap (on-line analytical processing?

0 Answers  


What do you mean by filter transformation?

0 Answers  


Categories