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 the use of Data Mart?

IBM,

5 7943

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

iGate, Qualcomm,

2 7905

performance tuning of Informatica

1 5313

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 9210

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 6489

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 8041

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 9195

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 7233

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

TCS,

1920

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

TCS,

1866

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

TCS,

2 7018

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

TCS,

2 6067

TELL ME ABOUT WORK FLOW SCHEDULING?

TCS,

3 8178

r u done any partitions in ur project?

TCS,

1827

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 11534


Post New Informatica Questions

Un-Answered Questions { Informatica }

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2357


What is the commit type if you have a transaction control transformation in the mapping?

1030


How can a transformation be made reusable?

1167


How do you set a varible in incremental aggregation

1891


What is Cognos script editor?

4229


What is meant by lookup transformation?

1108


How to do unit testing in informatica? How to load data in informatica ?

1120


How would you copy the content of one repository to another repository?

1016


Enlist the advantages of informatica.

1068


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1664


Explain in detail about scd type 1 through mapping.

1553


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2168


What is incremental aggregation?

1083


can you please explain me pre session and post session options?

7563