Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z




Accenture Informatica Interview Questions
Questions Answers Views Company eMail

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

 1 2971

Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 11321

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 6404

How to convert flat file into xml file? How to tune joiner?

 2 8193

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

 7 7496




what is shared lookup&persistent lookup?

 4 7182

what are the unix commands to start the wrk flow ?

 4 8155

What is the difference Between Mapping parameter and variable

 3 7002

What is update override?

 1 4371

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

 6 10026

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

 3 11115

1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?

2 15296

how to join the 2 different table with different columns in informatica?

 5 17948

How to load the source table into flat file target(with columns) in informatica?

 4 13686

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

 5 10593

Post New Accenture Informatica Interview Questions




Accenture Informatica Interview Questions





Un-Answered Questions

Explain deletion flag. Where is it used in archiving process?

11

. Using sed and grep, write a command which lists files and directories with following properties: (i) created in 1999 (ii) with user's as owner and group

1609

How Cassandra provide High availability feature?

3

How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What is the difference between them? How to handle script issues?

11

How to create a new view in mysql?

17




Explain access control?

9

why we used ZNO in Lightning arrester.

908

Differentiate between the verbose and minimal monitoring?

1

Explain about SAP Hybris module?

34

What do you mean by a sequential access file?

15

A crystal report developer uses sap crystal report for enterprise. To connect hana which connection type is preferred? : hana bi development

3

What is a Manifest file?

22

How is abstraction implemented in java ?

9

Which are the first soviet us space mission to moon?

4

Do you know what are acid properties?

7