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

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

L&T,

7 13841

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

L&T,

5 12375

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

BirlaSoft, Genpact, L&T, Syntel,

9 17052

can we see default group,when we use router?if yes how?

L&T,

2 7502

what is left outer join?

L&T,

3 8448

when we use dynamic lookup,if condition matches what will be the o/p?

L&T,

2 8383

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

L&T,

5 12562

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

L&T,

11 34482

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

CTS, Wipro,

6 11058

Target is zero file and how can you send the email?

Bank Of America,

2 11781

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 18955

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

Patni,

5 9987

how to remove staging area

1 5601

When we are using Dynamic Cache,which options we will select in session level?

Cognizant, CTS,

1 4541

h0w many versions have been developed of onformatica so far?

TCS, TetraSoft,

1 3088


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is meant by lookup transformation?

1110


how to load dimension table and fact table. plz tell me the steps.

2094


Can we get 1st record through Informatica(without sequence number).

1479


What will be the approach?

979


wat are deployement groups in informatica, how it will be used for developers

1719


Explain pushdown optimization $pushdownconfig parameter - informatica

1140


What are the differences between joiner transformation and source qualifier transformation?

1171


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

7566


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1085


Enlist the tasks for which source qualifier transformation is used.

1040


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1068


What is olap (on-line analytical processing?

1069


How many number of sessions can one group in batches?

1157


How to convert multiple rows to single row (multiple columns) in informatica

1381


Briefly explain the aggregator transformation?

1008