Informatica Interview Questions
Questions Answers Views Company eMail

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

TCS,

6 9670

what is the diff b/w cached and unchaed look ups

IBM, TCS, Wipro,

3 6571

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 7117

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 4400

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

IBM,

8 26739

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

IBM,

1 5228

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

Emirates, IBM,

10 12222

How to eliminate duplicates from flat file..what is the procedure

4 6598

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

IBM,

4 7739

what is datamart

IBM, Informatica,

4 6541

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

TCS,

2 4674

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

TCS,

4 12052

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

TCS,

5 8775

enterprise datawarehouse your project phase by phase explain?

Cap Gemini,

1 5519

what is mean by throghput? in informatica

Cap Gemini,

3 8527


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the meaning of up gradation of repository?

1362


Explain incremental aggregation in informatica

630


How many ways are there to do 'remove duplicate records in informatica'?

557


What are the databases that informatica can connect to windows?

557


What are the new features of informatica 9.x in developer level?

531






Explain the tuning lookup transformation - informatica

583


how many types of dimensions are available in informatica?

535


what is unit testing?tell me proceedure

1752


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1386


What is sq transformation?

637


How to create Target definition for flat files?

727


What is an expression transformation in informatica?

493


can we override a native sql query within informatica? Where do we do it? How do we do it?

579


What are the various types of transformation?

614


Design a mapping to load the cumulative sum of salaries of employees into target table?

868