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 11232

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,

6511

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

Accenture, Gcs, TCS,

119 81082

how to join two flat files in informatica?

Wipro,

3 16104

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

Wipro,

4 7046

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 6780

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

Cognizant, Wipro,

2 5044

how can we run workflow with pmcmd?

Wipro,

3 6578

what is bridge tables in informatica

CTS,

1 8409

what is the -ve test case in your project.

CTS, TCS,

1558

why union transformation is active transformation?

IndiGo, TCS,

6 20837

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 5872

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 32240

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

CTS,

1 6065

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 6974


Post New Informatica Questions

Un-Answered Questions { Informatica }

How to load the data from a flat file into the target where the source flat file name changes daily?

375


How to elaborate powercenter integration service?

390


What do you mean by filter transformation?

357


How can we remove the duplicates from flat file source?

352


Did u used latest transformations of 8.6.0? for what?

1283






In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1311


What are the types of schemas we have in data warehouse.

328


What is meant by LDAP users?

437


What is an Integration service in Informatica?

482


Explain what is informatica metadata and where is it stored?

408


Can anyone tell me the new features in Informatica 9 Version?

1312


Whats there in global repository

1049


explain about unit testing? in real time?

1401


Which transformation is needed while using the Cobol sources as source definitions?

469


What is data movement mode in Informatica and difference between them?

413