Informatica Interview Questions
Questions Answers Views Company eMail

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

IBM,

4 19657

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

IBM,

7 10418

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

Cognizant,

3 8082

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

Cognizant,

1 6128

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

IBM,

1 4013

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

IBM,

3 7744

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

3 5252

lookup transformation with screenshots

TCS,

3535

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

IBM,

3 6545

without using rank transformation how can we rank items by using some other transformations

2 13943

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 5922

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

TCS,

3 6146

Which will beter perform IIf or decode?

TCS,

3 17280

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1428

comonly how meny mappings r there in Banking projects?

1 4730


Post New Informatica Questions

Un-Answered Questions { Informatica }

Describe an informatica powercenter?

582


What is Index Caches size?

595


wf dont have integration severances how you can run?

1516


How to load the data from people soft hrm to people soft erm using informatica?

533


What is the session task and command task?

574






What is a difference between complete, stop and abort?

617


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1821


If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8471


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1674


What is intricate mapping?

564


where to store informatica rejected data?

647


What is resilience time?

634


What is a sorter transformation?

636


Scheduling properties,whats the default (sequential)

1438


How can one identify whether mapping is correct or not without connecting session?

844