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 6965

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

IBM,

1 4241

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 4181

What is diff between connected and unconnected lookup?

BirlaSoft, Blue Star Infotech,

5 6438

What is diff joiner and lookup

BirlaSoft,

4 6592

what is mapping parameter and mapping variables

BirlaSoft,

1 3892

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

BirlaSoft, IBM,

13 13660

without matching columns in two tables. how can you join

BirlaSoft,

5 9083

how to call lookup qualifer in unconnected look;up

BirlaSoft,

1 4536

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

1993

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 5996

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 4553

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 3750

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

ABC,

8 11806

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 5267


Post New Informatica Questions

Un-Answered Questions { Informatica }

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1303


What does update strategy mean, and what are the different option of it?

437


Explain the scenario which compels informatica server to reject files?

457


What is source qualifier transformation in informatica?

420


What is the use of an aggregator cache file?

499






What are the advantages of informatica?

425


What are the data movement modes in informatica?

492


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4651


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1476


Explain sql transformation in script mode examples in informatica

457


where to store informatica rejected data? How to extract the informatica rejected data?

439


what is the size of your data warehousing?

1494


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

403


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

1544


have u done any performance tuning? how u ll do?

1651