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 14096

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 12626

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 17339

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

L&T,

2 7610

what is left outer join?

L&T,

3 8604

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

L&T,

2 8505

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 12792

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 34912

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 11240

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

Bank Of America,

2 11928

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

8 19195

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 10170

how to remove staging area

1 5667

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

Cognizant, CTS,

1 4612

h0w many versions have been developed of onformatica so far?

TCS, TetraSoft,

1 3179


Post New Informatica Questions

Un-Answered Questions { Informatica }

How can a transformation be made reusable?

1242


What is fact table? Explain the different kinds of facts.

1129


What are the types of lookup transformation?

1120


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2052


difference between informatica 8.1.1 and 8.6

3732


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8313


explain about unit testing? in real time?

2265


Write the different tools in the workflow manager?

1119


Different qualification between a related rotate toward the sky and isolates look upward?

1041


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1311


Where are the source flat files kept before running the session?

1142


How many input parameters can exist in an unconnected lookup?

1605


What are the popular informatica products?

1059


Make a note of the quantity vaults made in informatica?

1046


Write the advantages of partitioning a session?

1337