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

checkout and checkin in informatica 8.6

TCS,

3 16714

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

TCS,

5 6640

How to Join Tables my Source is having 15 table target is one?

TCS,

4 5338

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

TCS,

2 5680

Can we use unconnected lookup as dynamic lookup?

ITC Infotech, TCS, Wipro,

5 13331

how did u understand business requirement?

TCS,

2 3917

What is the difference between writing a joiner query in ANSI style and THETA style?

TCS,

1470

Why we select the table which has minimum number of records as Master table in joiner?

HG, UST,

4 14503

can we use mapplet as starting n ending object in mapping

TCS,

2 3915

what is the predefined port in dynamic lookup

2 4090

my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4

Zensar,

2 5007

can any one give some examples for pre sql and post sql(Except dropping and creating index).

Zensar,

3031

What is the difference between SOURCE and TARGET BASED COMMITS?

IBM,

3 4173

What happens if we dont select data driven option?

Zensar,

2 5333

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

IBM, TCS,

1117


Post New Informatica Questions






Un-Answered Questions { Informatica }

What are mapplets?

230


What is transformation?

163


What are the restrictions of union transformation?

184


What are different types of transformations available in informatica?

191


What is a dimensional model?

190






Define Pmrep command?

201


What is primary and backup node?

223


whats the logic to load the lower level of granularity of data to fact table.

1323


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

459


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

179


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

195


What are the popular informatica products?

185


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?

1030


How do you manage the Parameter files while migrating your data from one environment to another environment?

193


Where do we use mapping variables in informatica?

194