Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Informatica Interview Questions
Questions Answers Views Company eMail

If we are using an aggregator but forget to mention the group by port .what will be the output??

Nomura, TCS,

11 34182

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 10779

can we create index and drop index in exsisting table while using infomatica

4 20014

"Change cache" in Informatica ?

2 7630

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 15954

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

5 19313

how we do performence tuning in informatica

3 7944

Diff b/w ShortCut and reusabel Object ?

4 8452

What are the ETL tools available in DWH?

Mphasis,

6 15293

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

iGate,

5 11930

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

iGate,

1 6935

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 8156

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

TCS,

3 10566

Router T/R is active but some people are saying it is also passive which is exactly right?

5 20415

how to convert the .doc docs into .txt format using informatica

4 12462


Post New Informatica Questions

Un-Answered Questions { Informatica }

Differentiate between a repository server and a powerhouse?

1118


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2107


What is the function of union transformation?

1134


What is a filter transformation?

1043


What is standalone command task?

1315


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7186


Can we create a Integration service without a Repository service and vice versa?

1215


Can we create a node as a gateway node and the same node can be assigned to a grid?

1079


What is a passive transformation?

1103


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10167


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

1080


How can we improve session performance in aggregator transformation?

1117


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8222


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

1090


How to update a particular record in target with out running whole workflow?

1576