Interview Questions Answers in Informatica

Question { TCS, 11976 }

There are n numbers of flatfile of exactly same format are
placed in a folder .Can we load these flatfile's data one
by one to a single relational table by a single session??

Answer

Yes BZZ,,,

After assign the folder path in Source path,
We have to change source Type as INDIRECT in Session
properties.

Is This Answer Correct ?

12 Yes

0 No

Question { TCS, 30763 }

If we are using an aggregator but forget to mention the
group by port .what will be the output??

Answer

No group by Port-
The AggTrans wil check for group by Column port up to last
column. No group by port was find,The AggTrans wil return
the last row only.
Every Column row wil check for Group by port done or not,
up to last row.
Finally (By default) last row will return.
Last Row still waiting for Group by port.,,,,
Thats why Group by prot is must.

Any Corrections,,,,,srinu.srinuvas@gmail.com

Is This Answer Correct ?

57 Yes

4 No

Question { 18463 }

can we create index and drop index in exsisting table while
using infomatica

Answer

I know 4 ways in INFORMATICA

1)Source Analyzer window-
(source table,Using key ports(enable,disable)).
2)Source qualifie Trans-
(Sql override)
3)Target override
4)Pre sql,Post sql

Any corrections,, srinu.srinuvas@gmail.com .

Is This Answer Correct ?

11 Yes

0 No

Question { 13552 }

If no. of source columns is changing every time (First time
it is 10 next time it is 20 so on). How to deal with it
without changing mapping?

Answer

Some one is not agree with Sathish Rajaiah
answer(1 No)ABOVE answer.
Let me Explain Why ?

Is This Answer Correct ?

0 Yes

1 No

Question { 6876 }

how we do performence tuning in informatica

Answer

Perf Tune is not an simple Question !!!!
its a process !!!

Performance of Informatica is dependant on the performance
of its several components like database, network,
transformations, mappings, sessions etc. To tune the
performance of Informatica, we have to identify the
bottleneck first. Bottleneck may be present in source,
target, transformations, mapping, session, database or
network.
Identify bottleneck in Source
Identify bottleneck in Target
Identify bottleneck in Transformation
Identify bottleneck in sessions
DATABASE OPTIMISATION
OPTIMUM CACHE SIZE IN LOOKUPS

so and so,,,,,,,,,,,,,,,,

Is This Answer Correct ?

5 Yes

2 No

Question { 7103 }

Diff b/w ShortCut and reusabel Object ?

Answer

Hi, REKHA
Can u check your answer ! Thanks for Posting.

""" A shortcut is created by assigning
'Shared' status to a folder within the Repository Manager
and then dragging
objects from this folder into another open folder"""""

If any Corrections Let me know
srinu.srinuvas@gmail.com

Is This Answer Correct ?

8 Yes

1 No

Question { iGate, 10208 }

Please let me know how we can implement the below scenario.
In a single mapping,more than 500 sources
(legacy,VSAM,relational) will be loading into only one
target. Whenever I retreive the data(any record) from
target, i need to find the details that the record belongs
to which source.

Thanks in advance..

Answer

Hi ,

After every Source qualifier transformation just keep an
Expression with flag.
Dont go Single Source qualifier trans.
Keep 1 source qualifier trans for one table.

Any corrections let me know ,,,,
srinu.srinuvas@gmail.com

Is This Answer Correct ?

3 Yes

2 No

Question { iGate, 6178 }

Please let me know how to do estimation before staring
development in project. Here estimation in the sense how
many associates are required, etc to complete the project.

Answer

Hi,

Its depends on Requirements like
Reports,
Data size,
Frontend work,(Develope maps,,,,)
Databases,
Interfaces.
Not only these ,,,Based Business Rerequirents,Projects
Duration,Project Amount also.

Is This Answer Correct ?

3 Yes

0 No

Question { TCS, 9178 }

HOw can we load the normalised data ( Vertical data) to
(Horizontal data)with out using decode in the expression
transformation and the aggregator transformation. But,
what exactly I want is .. If we have million of records,it
is not possible using decode and search for that Particular
Id to pivot into Horizontal data... Can any one of guys
please help me in this regard.....

Answer

Hi,

Check with Normaliser Transformation
it will help you.

Any queries !! let me know
srinu.srinuvas@gmail.com

Is This Answer Correct ?

3 Yes

7 No

Question { 18604 }

Router T/R is active but some people are saying it is also
passive which is exactly right?

Answer

Hi Guys,

First of all Every Active tranformation is a Passive
transformation,But every passive not Active.

In Router Transformation there is a special feature with
Default Group.Because of Default Group its Passive.
We can avoid this Default group by Some transformation
Settings,Now its Active.

any queries let me know
srinu.srinuvas@gmail.com,,,,,

Is This Answer Correct ?

15 Yes

3 No

Question { IBM, 5864 }

I am hvaing SOURCE as first line: 1000,null,null,null
second line as:null,2000,null,null 3rd line
as :null,null,3000,null and final line as:
null,null,null,4000 ............................Now i want
the OUTPUT as 1000,2000,3000,4000 For more clarification i
want to elimate nulls and want in a single line. Please
help me out

Answer

Just load the flat file.
(1000,null,null,null
null,2000,null,null
null,null,,3000,null
null,null,null,4000)
Go with Aggregate Trans formation with
MAX(field1)
MAX(field2),,,, .

Pls let me know if any corrections srinu.srinuvas@gmail.com

Is This Answer Correct ?

5 Yes

2 No

Question { 2894 }

any one can informatica metirial to me
ple forwrd to my mail id;

gbalireddy@gmail.com

Answer

Hi gbalireddy,

There no material for informatica except Informatica help-
contents-

If you want any specialized topics are Other then above
help Pls let me know, I wil try

srinu.srinuvas@gmail.com

Is This Answer Correct ?

1 Yes

0 No

Question { Accenture, 16128 }

How to load the source table into flat file target(with
columns) in informatica?

Answer

Seession Properties--> Mapping tab---> Target folder--->
Select the Target file --->Beside we will see
Tagetfilename.Filewriter in Properties.
one Property belongs to Header options.

From you can select your own style for Flat file only.

Any corrections pls let me know srinu.srinuvas@gmail.com

Is This Answer Correct ?

3 Yes

3 No

Question { Cap Gemini, 11964 }

In EMP table, for those emp whose Hiredate is same, update
their sal by "sal+500" or else for others keep the sal as it
is, how to do it by SQL query

Answer

Hi Sanjaygupta1981,

Can you please check the query once :
count(*) or count(hiredate).

Except Count(*) Your query looks good.

If any correctons in my advise please let me
know "srinu.srinuvas@gmail.com"

Is This Answer Correct ?

6 Yes

1 No

Question { 3402 }

if the session continuous run what can we do.
means shall we stop the session or abort session. what is the
correct reasion. why this situation occurs

Answer

In rare case some sessions will run long time ideally
without any data process.
The session log also will provide the information before
ideal run time only.
It occurs on server availability.

If the server hitting with many jobs at same time it
occurs.

Is This Answer Correct ?

0 Yes

0 No