Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

what is the need of session partitioning... how it is useful in real time

Amazon,

3 6165

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

IBM,

1 3767

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

IBM,

1 3810

What is diff between connected and unconnected lookup?

BirlaSoft, Blue Star Infotech,

5 5264

What is diff joiner and lookup

BirlaSoft,

4 5618

what is mapping parameter and mapping variables

BirlaSoft,

1 3290

if i am having 10 records in source, i want 20 records in target...how will you do it

BirlaSoft, IBM,

13 11275

without matching columns in two tables. how can you join

BirlaSoft,

5 7845

how to call lookup qualifer in unconnected look;up

BirlaSoft,

1 3842

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

1689

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

Span Systems,

5 4933

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

Span Systems,

3 3818

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

Span Systems,

2 3156

how to design mapping half of source table records into one target and remaining half into another target

ABC,

8 10475

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 4442


Post New Informatica Questions






Un-Answered Questions { Informatica }

Mention few power centre client applications with their basic purpose?

141


Explain the tuning lookup transformation - informatica

174


tell me about your project functionality

1403


What is meant by incremental aggregation?

143


What is rank transform?

148






What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

5228


On which transformations you created partitions in your project?

322


my source is junk data how will u remove that junk data by using unix please any one replay me

2788


What is the need for an etl tool?

157


difference between repository database and repository service?

201


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1183


What are the main issues while working with flat files as source and as targets ?

192


Explain the types of transformations?

136


What is the difference between a connected look up and unconnected lookup?

157


Can we create a Integration service without a Repository service and vice versa?

197