Interview Questions Answers in Informatica

what is the use of Data Mart?

Answer

Data mart is a subset of data ware housing.it is a complete
information about one particular domain.

ex:finance,hr,sales.....

chandumba2005@gmail.com

Is This Answer Correct ?

4 Yes

0 No

Question { 9097 }

In a table there are 1 million records there in which 3
records are duplicate how will you find out those 3 records?

Answer

write a query eg:take emp table and empno,sal,deptno columns
have assume the duplicates.

select * from emp x where rowid>(select min(rowid) from emp
where empno=x.empno
and sal=x.sal
and deptno=x.deptno);

you will only duplicate records in the emp table.
chandumba2005@gmail.com

Is This Answer Correct ?

3 Yes

0 No

Question { iNautix, 24724 }

How to load last 10 records of flat file in to the target?

Answer

By using UNIX command tail command .
it display last N lines file.By default it display last 10
lines.
$tail file name

Is This Answer Correct ?

10 Yes

0 No

Question { HP, 6017 }

why we r using presql&postsql in source qualifier?

Answer

Presql :sql statement executed before the session retrive
the data from source.
Postsql:sql statement executed atfer the session retrive the
data from source.

Is This Answer Correct ?

10 Yes

0 No

Question { HP, 6886 }

how i will stop my workflow after 10 errors

Answer

sesseion level property error handling mention condition
stop on errors :10

Is This Answer Correct ?

17 Yes

0 No

Question { HP, 7370 }

I have source like this 1:2;3. so i want to load the target
as 123

Answer

S.D--->S.Q....>EXP T/R......>TGT

In exp t/r create one out put port give condition
by using Replace function we can achieve this scenario.

or sql query :

select replace('1:2;3','1:2;3','123') from dual;
ans:

REP
---
123

Is This Answer Correct ?

5 Yes

0 No

Question { HP, 5814 }

what is the size of u r project? and what is the size of
source file?

Answer

It might be in TB's

Is This Answer Correct ?

5 Yes

0 No

Question { Cap Gemini, 24811 }

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

Answer

Select * from (select rownum as rno, emp.* from emp) where
rno in (1,2,5);

Is This Answer Correct ?

6 Yes

2 No

Question { Cap Gemini, 24811 }

how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me

Answer

Select * from (select rownum as rno, emp.* from emp) where
rno in (1,3,5);

Is This Answer Correct ?

4 Yes

0 No

Question { 12599 }

i want excute multiple sessions in one workflow using the
"start task".what do i need to do?

Answer

Just give the connections from start task to sessions either
sequential or parallel.

Is This Answer Correct ?

0 Yes

2 No

Question { Cap Gemini, 42333 }

How can you change from reusable session into non-reusable
session.

Answer

We can't change

Is This Answer Correct ?

27 Yes

26 No

Question { Cap Gemini, 42333 }

How can you change from reusable session into non-reusable
session.

Answer

If u devlope the session in work flow manager that is
standlone session.that is not reusable first.we can't
achieve if you create session in work flow.

Is This Answer Correct ?

2 Yes

2 No

Question { TCS, 9683 }

write a query following source
region sales
1 1000
2 2000
i want the output ?please give solution
1 2
1000 2000

Answer

BY USING NORMALIZER T/R WE CAN ACHIEVE THIS SCENARIO.

I hope i have given right solution.

Is This Answer Correct ?

7 Yes

5 No

Question { Yash Technologies, 9787 }

I want load the data into target with out 1st and last record.

Answer

for flat file how can you do it

Is This Answer Correct ?

0 Yes

0 No

Question { Cognizant, 10378 }

How can you display only hidden files in UNIX

Answer

Correct answer is

ls -a|grep "^\."

Is This Answer Correct ?

14 Yes

0 No

chandra sekhar