1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
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 30760

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 9370

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

 4 18458

"Change cache" in Informatica ?

 2 6570

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 13533

What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?

 5 17505

how we do performence tuning in informatica

3 6870

Diff b/w ShortCut and reusabel Object ?

 4 7096

What are the ETL tools available in DWH?

Mphasis,

6 13307

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 10192

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 6176

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 6945

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 9170

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

 5 18588

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

 4 11149

Post New Informatica Questions

Un-Answered Questions { Informatica }

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

630

On which transformations you created partitions in your project?

761

what is the size of your data warehousing?

1673

Define pmcmd command?

624

Explain the difference between a data warehouse and a data mart?

600




What is domain and gateway node?

698

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1462

Separate from a database, an information bazaar, and an information stockroom?

611

Define Pmrep command?

642

What are the main issues while working with flat files as source and as targets ?

657

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1085

How can we create index after completion of load process?

600

What are the differences between a connected lookup and unconnected lookup?

652

How to use pmcmd utility command?

584

What is the benefit of session partitioning?

597

For More Un-Answered { Informatica } Questions Click Here