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

what is the use of Data Mart?

IBM,

5 6158

Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project

iGate, Qualcomm,

2 6889

performance tuning of Informatica

 1 4571

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

Informatica,

5 7586

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

Sapient,

2 5544

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

IBM,

3 6782

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

Polaris,

5 7563

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

Polaris,

4 5853

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

TCS,

1500

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

TCS,

1452

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

TCS,

2 6118

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

TCS,

2 5115

TELL ME ABOUT WORK FLOW SCHEDULING?

TCS,

3 6812

r u done any partitions in ur project?

TCS,

1386

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

Polaris,

3 10361

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is rank transformation in informatica

678

What are the limitations of joiner transformation?

641

Is there any way to read the ms excel datas directly into informatica?

536

What is transformation?

649

How do you migrate data from one environment to another?

632




What is informatica worklet?

591

what is Active lock explain

2360

How to go to the older version for a mapping?

586

What is dynamic cache?

600

What is the use of target designer?

593

How might one distinguish in the case of mapping is right or not without associating session?

627

Can informatica load heterogeneous targets from heterogeneous sources?

684

What is the function of look up transformation?

637

As union transformation gives UNION ALL output, how you will get the UNION output?

630

Differentiate between reusable transformation and mapplet.

553

For More Un-Answered { Informatica } Questions Click Here