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

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 7748

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

IBM, TCS, Wipro,

3 5159

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 4995

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 3463

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 23331

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 4275

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 9563

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

4 5131

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 6291

what is datamart

IBM, Informatica,

4 5055

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 3656

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

TCS,

4 10160

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 7136

enterprise datawarehouse your project phase by phase explain?

Cap Gemini,

1 4706

what is mean by throghput? in informatica

Cap Gemini,

3 6794


Post New Informatica Questions






Un-Answered Questions { Informatica }

how to load rows into fact table in data warehouse

203


What is rank transformation in informatica

188


wf dont have integration severances how you can run?

1077


Explain what is informatica metadata and where is it stored?

160


What is exclusive and normal mode for repository services?

175






what is Active lock explain

1905


How many input parameters can exist in an unconnected lookup?

212


What is a predefined event?

135


What are the types of presistent cache in look up tr.

1060


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

148


How to use procedural logic inside infromatica?

150


What is decode in informatica?

165


Why union transformation is an active transformation?

192


What is source qualifier transformation in informatica?

152


What is status code in informatica?

140