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

what is diff between grep and find

IBM, iFlex,

3 8250

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

Infosys, ITC Infotech,

7 24185

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 6322

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

2 13838

How Union Transformation is an Active Trans?

6 16264

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

PCS,

4 9313

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 5726

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

CSC,

10 28821

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

5 4377

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

7 11963

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 4272

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 4956

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

Infosys,

1 5710

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

5 6803

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 5749


Post New Informatica Questions






Un-Answered Questions { Informatica }

Enlist some properties of sessions.

160


Describe the impact of several join conditions and join order in a joiner transformation?

174


define galaxy repository in informatica

1247


What is standalone command task?

181


What is the need of an ETL tool?

185






Can we change Dynamic to Static or Persistent cache? If so what happens?

1218


Explain Dataware house architecture .how data flow from intial to end?

1650


What are the different types of olap? Give an example?

131


can anyone explain me about retail domain project in informatica?

5872


What are the static cache and dynamic cache in informatica?

158


what is SDLC way of code development?

1094


Slowly changing dimensions, types and where will you use them

790


What is dynamic cache?

145


Different sorts of metadata that stores in the storage facility?

158


Clarify the utilization of aggregator cache record?

141