1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

checkout and checkin in informatica 8.6

TCS,

3 18424

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

TCS,

5 8316

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

TCS,

4 6692

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 6734

Can we use unconnected lookup as dynamic lookup?

ITC Infotech, TCS, Wipro,

5 15911

how did u understand business requirement?

TCS,

2 4785

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

TCS,

1903

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

HG, UST,

4 17971

can we use mapplet as starting n ending object in mapping

TCS,

2 4790

what is the predefined port in dynamic lookup

 2 5076

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 6212

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

Zensar,

3492

What is the difference between SOURCE and TARGET BASED COMMITS?

IBM,

3 5409

What happens if we dont select data driven option?

Zensar,

2 6398

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,

1541

Post New Informatica Questions

Un-Answered Questions { Informatica }

Differentiate between source qualifier and filter transformation?

987

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

549

is it possible to index the data in cache of lkp transformation ?

1513

How to join three sources using joiner?

556

Separate from a database, an information bazaar, and an information stockroom?

596




draw informatica architecture 8.6 ?

3461

Design a mapping to load a target table with the following values from the above source?

866

Explain lookup transformation in informatica

639

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

679

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1621

Why sorter is an active transformation?

740

What is the advantage of informatica?

636

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

1677

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

1903

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

532

For More Un-Answered { Informatica } Questions Click Here