Informatica Interview Questions
Questions Answers Views Company eMail

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

IBM,

10 13134

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,

6784

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

Accenture, Gcs, TCS,

119 96655

how to join two flat files in informatica?

Wipro,

3 17596

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

Wipro,

4 7967

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 7925

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

Cognizant, Wipro,

2 5786

how can we run workflow with pmcmd?

Wipro,

3 7527

what is bridge tables in informatica

CTS,

1 9280

what is the -ve test case in your project.

CTS, TCS,

1896

why union transformation is active transformation?

IndiGo, TCS,

6 22263

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 6671

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 34162

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

CTS,

1 6578

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 7942


Post New Informatica Questions

Un-Answered Questions { Informatica }

Which is the t/r that builts only single cache memory?

766


How to Create a folder using pmrep command?

657


Explain lookup transformation source types in informatica

735


What are the reusable transformations?

733


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1622






how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1737


What do you understand by term role-playing dimension?

631


can anyone suggest best free Talend data integration training online

1299


Explain the types of transformations?

634


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1890


Explain sessions and how many types of sessions are there?

622


complex mapping ur project u r invlve can u explain and give real time example give me ?

1890


What is depict expression change?

658


What is lookup change?

652


COM components can be used in Informatica

1923