Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Informatica Interview Questions
Questions Answers Views Company eMail

If I have a index defined on target table and if set it to bulk load will it work ?

IBM,

4 15393

When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

IBM,

3 17392

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

IBM,

11 18685

how can we check whether a particular cache is static or dynamic?

InfoCepts, TCS,

1 8152

Can any one explain or sujjest some sites for scd mappings.Thank you

Wipro,

1 4889

Difference between session variables and workflow variables?

Informatica,

2 20489

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 13137

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

TCS,

5 7916

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2699

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 7915

how many data models u have done in informatica project?

TCS,

2 8156

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 11223

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

TCS,

6 10679

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

Ness Technologies,

2 7305

How can we get two output ports in un-connect transformation?

Ness Technologies,

2 7360


Post New Informatica Questions

Un-Answered Questions { Informatica }

During the running session, output files are created by informatica server. Enlist few of them.

947


How to generate sequence numbers using expression transformation?

1038


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1592


What is dimensional table?

1018


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,

7135


What are the different types of repositories created using informatica?

1073


how tokens will generate?

2163


Explain the difference between mapping parameter and mapping variable?

998


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6947


what is the size ur source like(file system or database)? how many record daily come u r banking project?

2106


Target increases every day even though no new record was inserted

1526


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1016


can you please explain me pre session and post session options?

7450


Explain sessions. Explain how batches are used to combine executions?

965


What does refresh system mean, and what are its distinctive choice?

1101