How to create the source and target database connections in server manager?


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

Post New Answer

More Informatica Interview Questions

What are the tasks that Loadmanger process will do?

1 Answers  


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,


What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,


in oracle write query yourname+1 from dual

5 Answers  


Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,






Tell me about MD5 functions in informatica

0 Answers  


If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 Answers  


What is an unconnected transformation?

0 Answers   Informatica,


what is the diff b/w union and joiner and lookup?

4 Answers  


What is the cumulative sum and moving sum?

0 Answers  


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  


Quickly characterize reusable change?

0 Answers  


Categories