Interview Questions Answers in Informatica, SQL PLSQL

How to list Top 10 salary, without using Rank Transmission?

Answer

select distinct a.sal from emp a where 10>=(select
count(distinct b.sal from emp b where a.sal<=b.sal)order by
a.sal desc

Is This Answer Correct ?

0 Yes

1 No

Question { L&T, 31662 }

Data is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?

Answer

yes valid.suppose take sequence generator t/r drag the
nextval port into exp t/r from exp t/r drag all ports into
router t/r,from router t/r drag default group into one target.
when u connect default group into target then it is passive.

Is This Answer Correct ?

1 Yes

1 No

Question { L&T, 12137 }

i have one source 52 million records i want target only 7
records ?how wil you do what logic to implement?

Answer

IF U WANT LOAD 7 RECORDS FROM SOURCE TO TARGET,
WE CAN USE SEQUENCE GENERATOR T/R
CURRENT VALUE =0
END VALUE =7
RESET ENABLE
THEN DRAG THE NEXTVAL PORT TO EXP T/R
CREATE ONE OUTPUT PORT GIVE THE CONDTION LIKE NEXTVAL =7.

PLZ LET ME IF ANY WRONG

Is This Answer Correct ?

4 Yes

0 No

Question { Synechron, 33850 }

From an Employee table, how will you display the record
which has a maximum salary?

Answer

sql> select * from emp where sal=(select max(sal) from emp);

chandumba2005@gmail.com

Is This Answer Correct ?

2 Yes

0 No

Question { Sonata, 14717 }

what is sql override?what is the use of it?

Answer

It is a process of defining the user defined SQL queries to filter data, joining the data ,sorting the data and eliminating duplicate records.

Is This Answer Correct ?

0 Yes

1 No

Question { Deloitte, 38326 }

How we can get unique records into one target table and
duplicate records into another target table??

Answer

sq-->Aggregator-->Router-->target

select group by for port name empno

in aggregater t/r take 1 output port and give condition like

select group by for port name empno

varcount---->count(*)

connect this one router and in router take 2 groups and
give condition like

uniqe_record :varcount=1-----for unique

duplicate_record :varcount>1 ----for duplicate

and connect that groups to target.

u will get result.

Is This Answer Correct ?

7 Yes

10 No

Question { iGate, 12192 }

i want to load data in to two targets..one is dimension
table and the other is fact table?how can i load ata a time

Answer

use surrogate pipeline technique first data loaded into dimension table ,then loaded into fact fable with primary and foreign key technique b/w dimension and fact table.

use lookup t/r.........

Is This Answer Correct ?

2 Yes

0 No

Question { IBM, 8050 }

how may sources can be used in a mapping at a time?(limit)

Answer

WE CAN USE ANY NO OF SOURCES IN A MAPPING AT A TIME.THERE IS NO LIMIT.

Is This Answer Correct ?

3 Yes

0 No

Question { Cap Gemini, 29320 }

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND
LOOKUP?

Answer

If two flat files are having same structure then we can join
by using Union transformation.

Chandu

Is This Answer Correct ?

16 Yes

1 No

Question { BTBP, 6623 }

can you please explain me pre session and post session options?

Answer

1)Pre session:session execute data before loading the data into target.
2) post session :session execute data after loading the data into target

Is This Answer Correct ?

5 Yes

2 No

Question { iNautix, 10777 }

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4
session after 5th session how will you do?

Answer

wkf--s1----s2----s3---s4---Eventraise
eventwait-----s5

first run execute four sessions successfully eventraise task
give the signal to Event wait task to execute the session 5(S5)

Is This Answer Correct ?

17 Yes

3 No

Question { 7776 }

Hello......
How can i set my mapping as read-only?
Please answer me. Advance thanks

Answer

Use Version controls select checkin option

if u ckeckin mapping is readony
if u checkout then you can edit the mapping

Is This Answer Correct ?

6 Yes

0 No

Question { 7776 }

Hello......
How can i set my mapping as read-only?
Please answer me. Advance thanks

Answer

if u checkin the mapping then mapping will be read only mode

Is This Answer Correct ?

1 Yes

0 No

Question { IBM, 7005 }

why union is active transformation?

Answer

Union it support only same metadata in both the tables.
it will execute same metadata.
it means reject the unmatched data.
so reject some records.
so it changes the no of records

Is This Answer Correct ?

2 Yes

7 No

Question { DELL, 11655 }

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute
s1,s2,s3,s5 after s4. How?

Answer

my question is first execute s1,s2,s3,s5 after that execute s4.

Is This Answer Correct ?

1 Yes

0 No

chandra sekhar