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 7963

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

iGate, Qualcomm,

2 7912

performance tuning of Informatica

1 5323

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 9228

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 6498

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 8053

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 9210

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 7250

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

TCS,

1924

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

TCS,

1868

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

TCS,

2 7028

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

TCS,

2 6079

TELL ME ABOUT WORK FLOW SCHEDULING?

TCS,

3 8191

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 11543


Post New Informatica Questions

Un-Answered Questions { Informatica }

Enlist the advantages of informatica.

1070


How can you increase the performance in joiner transformation?

1194


what are the deliverables?in your project?

2152


How to improve the performance of a session using sorter transformation?

1150


In warehouses how many schemas are there?

1078


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7258


Where is metadata stored?

1122


What is mapplet in informatica?

1064


Explain the informatica workflow?

1074


Have you worked with/created Parameter file

1668


Mention few advantages of router transformation over filter transformation.

1027


Define mapping and session?

1040


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1093


How to generate sequence numbers without using the sequence generator transformation?

1212


What are the different transaction levels available in transaction control transformation?

1211