Interview Questions Answers in Informatica, SQL PLSQL, Unix Commands

What is difference between TRUNCATE & DELETE?

Answer

Truncate Delete
1)it is DDl command it is DML command
2)it delete records permanently it delete records temporarly
we can't roll back we can roll back the data

Is This Answer Correct ?

1 Yes

0 No

Question { 13333 }

what is the use of uniq commmand?

Answer

simple it display the unique data in the file

Is This Answer Correct ?

0 Yes

0 No

Question { 9615 }

What is aggregate cache in aggregator transforamtion?

Answer

unsorted data loading into aggregate cache.

Is This Answer Correct ?

0 Yes

1 No

Question { 10682 }

In a sequential batch can you run the session if previous
session fails?

Answer

YES.
BUT If U GIVE ANY CONDITION LIKE $SESSION1.STATUS=SUCCEEDED,
IF THE SESSION1 SUCCEEDED THEN IT WILL RUN SESSION2 ,SUPPOSE SESSION1 FAILED THEN IT CAN'T RUN THE SESSION 2.

above example: if the session1 failed it can't run another session.if u can't give any condition it will run second session.

Is This Answer Correct ?

4 Yes

0 No

Question { 9203 }

What are reusable transformations in how many ways we can
create them?

Answer

Reusable Transformations are

1)Lookup t/r
2)stored procedure
3)sequence generator t/r

two ways we can create
1)Mapplet (multiple t/r)
2)Transformation devloper (single t/r)

Is This Answer Correct ?

0 Yes

2 No

Question { IBM, 52083 }

how to retrive only second row from table?

Answer

SQL> select * from (select rownum as rno,emp.* from emp)
2 where rno=&n;
Enter value for n: 2
old 2: where rno=&n
new 2: where rno=2

RNO EMPNO ENAME JOB MGR
HIREDATE SAL
---------- ---------- ---------- --------- ----------
--------- ----------
COMM DEPTNO
---------- ----------
2 7499 ALLEN SALESMAN 7698
20-FEB-81 1600
300 30

Is This Answer Correct ?

1 Yes

0 No

Question { 32152 }

what is dimension table?

Answer

Dimension table it consist master data and Non-numeric data

Is This Answer Correct ?

1 Yes

3 No

Question { TCS, 19476 }

how do u get the first record from 50,000 records ?

Answer

Select * from(select rownum as rno,emp.* from emp) where rno=&n
EX:

SQL> Select * from(select rownum as rno,emp.* from emp) where rno=&n;
Enter value for n: 1
old 1: Select * from(select rownum as rno,emp.* from emp) where rno=&n
new 1: Select * from(select rownum as rno,emp.* from emp) where rno=1

RNO EMPNO ENAME JOB MGR HIREDATE SAL
---------- ---------- ---------- --------- ---------- --------- ----------
COMM DEPTNO
---------- ----------
1 7369 SMITH CLERK 7902 17-DEC-80 800
20

Is This Answer Correct ?

0 Yes

2 No

Question { 9999 }

how to load duplicate row in a target

Answer

with out p.key in the target table we can load.

Is This Answer Correct ?

1 Yes

0 No

Question { 35594 }

what is upstream and downstream transformation?

Answer

above source qualifier upstream transformation and
expression is down stream transformation

Is This Answer Correct ?

4 Yes

3 No

Question { HSBC, 21967 }

we r using aggregator with out using groupby?

Answer

If you are using groupby the integration service produces
one row for each group, if you do not use groupby the
integration service returns one row(last row) for all input
rows.

chandumba2005@gmail.com

Is This Answer Correct ?

4 Yes

0 No

Question { HSBC, 8239 }

how to we create datamart?

Answer

Data mart is a subset of Data warehouse.it is a complete information about one particular domain.eg:(finance,sales).

Data marts and Data warehouses are built on dimensional
data modeling where the relationship b/w dimension tables fact tables.

Is This Answer Correct ?

0 Yes

0 No

Question { 18408 }

how will you remove the duplicate records from flat file
without using sorter?

Answer

SD---S.Q----EXP t/r------TGT.

add two port in exp t/r.
one is variable port v_seq expression:seq+1
one output port o_seq expression:v_seq
required ports connect to target.

Is This Answer Correct ?

1 Yes

4 No

Question { 10605 }

How to retrieve last two days updated records?

Answer

by using date range.we can find latest date updated records.

Is This Answer Correct ?

0 Yes

0 No

Question { Infosys, 43360 }

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

Answer

write sql query in the source qualifier t/r

sql override

select * from(select dense_rank () over (order by sal desc
nulls last)as rnk,emp.* from emp)where rnk<=10;

Is This Answer Correct ?

0 Yes

3 No

chandra sekhar