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

what is diff between grep and find

IBM, iFlex,

3 11122

how can we load first and last record from a flat file source to target?

Infosys, ITC Infotech,

7 29181

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

KPIT,

1 7866

What are partitions in informatica and which one is used for better performance?

2 15888

How Union Transformation is an Active Trans?

6 20049

What is a surrogate key?Why we use it in a mapping?Pl give an example.

PCS,

4 12256

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

CSC,

3 8182

Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

CSC,

10 34186

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 7473

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 18418

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 6443

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 7139

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

Infosys,

1 7622

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 10099

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 7683


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is meant by LDAP users?

1121


How many ways a relational source definition can be updated and what are they?

961


What are the different transaction levels available in transaction control transformation?

1129


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2323


Mention a few design and development best practices for informatica?

941


What do you mean by channel change?

972


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2007


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1858


Where are the source flat files kept before running the session?

1020


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2231


How do you update the records with or without using update strategy?

1064


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1086


Have you worked with/created Parameter file

1620


Performance tuning( what you did in performance tuning)

1918


How to call shell scripts from informatica?

940