1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Hi experts, For informatica developer, in real time,
normally how much we use sql and plsql?

Question Posted / pvnkumar907

Answers were Sorted based on User's Feedback



Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?..

Answer / ajay konidena

we can't say how much we use .
it is depend on the project requirement so
u must have deep knowledge on both sql,plsql of any DB

Is This Answer Correct ?    9 Yes 1 No

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?..

Answer / chinni

If your'e well versed with Oracle. In performance point of
view use pre-sql and post-sql or sql query in source
qualifier transformation. If your'e having minimal
knowledge on sql or pl/sql then go for Informatica bcz its
a 3rd party tool which will give solutions in less time
than Normal Oracle.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

How can we handle two sessions in informatica?

0 Answers  

what is curr val use for in sequence generator?

2 Answers   Emphasis,

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

what is update strategy transformation ?

7 Answers   TCS,

While migrating the data from one environment to another environment how would you manage the connections?

0 Answers  




What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

5 Answers   CTS,

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

How can one identify whether mapping is correct or not without connecting session?

0 Answers  

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories