Interview Questions Answers in Informatica

Questions / { venkatesh }

Questions Answers Category Views Company eMail

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Informatica 7786

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

TCS,

5 Informatica 7099

Answers / { venkatesh }

Question { 17034 }

How to merge First Name & Last Name?

Answer

let the source is like this
first name last name
venkatesh malneni
rajesh tumalla
siva kalle

use an expression t/r create an output port with condition first name||last name
CONNECT THE OUTPUT TO THE TARGET

Is This Answer Correct ?

1 Yes

0 No

Question { 5541 }

If one flat file contains n number records., we have to load
in target from 51 to 100.. how to use expressions in
Informatica..?

Answer

Generate sequence by using sequence generator or by using expression t/r
connect the output to the filter t/r in filter write the condition as sno>=51 and sno=100
connect it to the target

src--->sq---> expression--->filter--->target

Is This Answer Correct ?

1 Yes

0 No

Question { Sonata, 14351 }

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

Answer

we can write the sql queries in sql override.by using this sql override we can reduce the no of t/r in a mapping.

if no please let me know the correct answer

Is This Answer Correct ?

8 Yes

1 No

Question { 5543 }

how can we calculate fact table size?

Answer

A fact table is multiple of combination of dimension tables

ie if we want 2 find the fact table size of 3years of
historical date with 200 products and 200 stores

3*365*200*200=fact table size

Is This Answer Correct ?

3 Yes

2 No

Question { 6795 }

how to delete duplicate records by using filter
transfermation?

Answer

by using only filter t/r we cannot delete duplicate records.
but by using combination of aggrigator and filter t/r we can achive it

in aggrigator t/r create a new o/p port to count_rec with expression count(key column)
connect all the ports to filter and write a condition count_rec=1.now connect ports to the target

Is This Answer Correct ?

5 Yes

1 No

Question { TetraSoft, 12750 }

How to delete first 3 rows & last 3 rows in target table in
informatica

Answer

FIRS PIPELINE
BY using sequence generator t/r generate sequence
numbers(sno)
in rank t/r,from sq connect all the ports to the rank
t/r,rank by sno,select top 3 ranks
SECOND PIPELINE
connect the nextval port from sequence generator to sorter
t/r
from sq connect all the ports to the sorter t/r,connect all
the ports to the filter t/r.in filter t/r write a condition
sno>3.

connect the o/p of the two pipelines by using UNION T/R
connect the o/p of the Union t/r to aggrigator t/r group by
sno.create an o/p port with name count_sno to
count(sno),connect the o/p from aggrigator t/r to the filter
t/r write the condition count_sno=1.
connect the o/p from filter to trg
THE DATA FLOW DIAGRAM IS LIKE THIS
sequence generator
| |
| \|/
src--->sq--->rank------>union--->aggrigator---->filter->trg
| | /
\|/ \|/ /
sortet----->filter/

If am wrong please let me know

Is This Answer Correct ?

1 Yes

1 No

Question { TetraSoft, 12750 }

How to delete first 3 rows & last 3 rows in target table in
informatica

Answer

Is This Answer Correct ?

2 Yes

0 No

Question { TCS, 5523 }

Which is better performance wise database or file?How?

Answer

files are better in performance than database.
because database has to connect to the odbc,and some drivers to extract or load the data.
But in case of file we directly extract or load the data.so,as per the performance files are better

Is This Answer Correct ?

3 Yes

0 No

Question { Wipro, 17407 }

how to join two flat files in informatica?

Answer

If the structure of the two flat files is same we can use SQ.by using in direct

if there is no common field in the two flat files then
create dummy columns in the exp t/r and then by using the dummy columns u can join them in the joiner t/r by giving the condition dummy = dummy1.
the flow is like this

src1--->SQ----->exp--->
|--->joiner---->target
src2--->SQ----->exp--->

Is This Answer Correct ?

10 Yes

0 No

Question { Wipro, 7769 }

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

Answer

if we do the performance optimization we can achieve the task i think (ie we can reduce the time of loading the data into target)

if my answer is wrong please let me know the write answer

Is This Answer Correct ?

1 Yes

1 No

Question { Wipro, 5704 }

in what type of scenario bulk loading and normal loading we use?

Answer

We use bulk loading in such senarious where there is bulk amount of data is to be loaded into target.
ie we when we want yo load large amount of data fast into the target we use bulk loading.
when u dont want to do the session recovery and u r target should not contain any primary keys
we use normal loading in such senarious when u want to do session recovery.It looks about the constrain based
loding

Is This Answer Correct ?

3 Yes

0 No

Question { TCS, 22074 }

why union transformation is active transformation?

Answer

If the source1 has 10 records and the it contains 3 records
and the same 3 records are in the second source,the second
source contains 10 records if we want to join them using union
t/r then the output is 17 records instead of 20 records.
thats why we say that UNION T/R is active t/r

Is This Answer Correct ?

3 Yes

32 No

Question { CTS, 33962 }

1)how to generate sequnce numbers in informatica without
using sequnce genarator transformation.

2)i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.

3)i want to update the records without using updatestrategy
transformation.

4)what is diffrance between ab-intio and datastage than
compared to informatica.

5)what is the latest version of informatica in our field.

Answer

How to generate sequence numbers in informatica with out using sequence generator t/r

we can generate sequence numbers in informatica by using expression transformation also.In expressin t/r create 3 new ports
1)var_1 as variable port and in expression give value as val
2)val as variable port and in expression give value as val+1
3)sequence output port and in expression give val
and connect the output port to target

Is This Answer Correct ?

35 Yes

14 No

Question { CTS, 33962 }

Answer

i have number of records in my sourse, but iwant to
display first and last record only. how it is possible in
informatica.

Generate sequence numbers to ur source
connect it to filter t/r and write a condition sno=1 connect it to the target

in second pipeline connect source qualifier to aggreator t/r don't select any group by (so that it will gives it last record) connect output to the target

the flow is like this
sequence generator|
|
\|/
src--->sq--->filter--->target
|
|--->aggrigator--->target

Is This Answer Correct ?

15 Yes

1 No

Question { 7786 }

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104
MY REQUIRMENT IS
NAME ID
VENKATESH 101
RAJESH 102
SIVA 103
SWATHI 104

PLEASE PROVIDE ME THE SOLUTION

Answer

hai vijaya

will u please explain me in detail

Is This Answer Correct ?

0 Yes

0 No