Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

If the records doesnt satisfy the filter condition where will it go?

IBM,

10 9903

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,

HCL,

6295

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

Accenture, Gcs, TCS,

119 68973

how to join two flat files in informatica?

Wipro,

3 14629

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

Wipro,

4 6245

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

Wipro,

5 5860

in what type of scenario bulk loading and normal loading we use?

Cognizant, Wipro,

2 4309

how can we run workflow with pmcmd?

Wipro,

3 5962

what is bridge tables in informatica

CTS,

1 7795

what is the -ve test case in your project.

CTS, TCS,

1320

why union transformation is active transformation?

IndiGo, TCS,

6 19433

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 5271

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.

CTS,

5 31186

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

CTS,

1 5556

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 6362


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is powercenter on grid?

181


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1544


How will the document be delivered to me?

176


Can you use flat files in Mapplets.

1626


What are the differences between source qualifier and joiner transformation?

170






What are the components of the workflow manager?

179


Differences between connected and unconnected lookup?

171


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

160


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

193


Can u generate reports in Informatica?

221


How to elaborate tracing level?

163


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

171


Explain load alternative records / rows into multiple targets - informatica

225


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

215


Repository user profiles

929