Interview Questions Answers in Informatica, Teradata

Question { IBM, 21262 }

What is data quality? How can a data quality solution be
implemented into my informatica transformations, even
internationally?

Answer

Data wili have Special characters,Symbols,Nulls,Zeros,,,
You need Cure the Data using Default values,Null
updates,,,like many things r there,,
In Inf trans Avoid the nulls,Correct DataType with
Length,Unique data,,,,like,,many ways u can cure the data.

Is This Answer Correct ?

0 Yes

3 No

Question { 6897 }

can we have an unconnected lkp to lookup a DB2 record
against a Teradata record?

Answer

Yes,,
We can use like Like,(Diff Databases)

Is This Answer Correct ?

1 Yes

0 No

Question { 8379 }

How will u pas the data with out debugger?

Answer

Hi Nithyanandan,,

The Debugger will show the data flow from Sql trans TO
Target only.
How source rows are transfor ONE Trans to Another Trans up
Target we can watch phisically also,
and watch the Rejected rows also.

srinu.srinuvas@gmail.com

Is This Answer Correct ?

3 Yes

2 No

Question { 4067 }

What is a configuration management?

Answer

Power Center Repository service :Manage the connections
from Repository from Clint application.

Power Center Intigration service :Run the Power Center
Sessions,Workflows and fetch the Metada from Power center
Repository.

Metadata Menager service :Runs the metadata manager
application in the power center domain.

Reporting Service :Runs the data analyser application in
the power center domain.You creat a reporting service to
run reports on power center or Matadata manager Repository.

Not only these ,,,,
All Configaration related things will come under
configuration management.

If there is any Corrections Please let me know.
srinu.srinuvas@gmail.com

Is This Answer Correct ?

0 Yes

0 No

Question { MBT, 44761 }

can anyone explain me about sales project in informatica?

Answer

Dont think so,,
Jsut say :in Total EDW my modulele is Customer data
maintaince,We follow up his History to Present data.
We are using 4 Facts,7 dimemenstions in Star schema.

Try develope this way of Explanation,,,,All the best,,,

Is This Answer Correct ?

8 Yes

12 No

Question { Wipro, 5716 }

Hi,

Can someone send me the DWH and Informatica FAQ's at
vanibv6@gmail.com
Thanks in Advance,
Vani

Answer

Test mail to
srinu.srinuvas@gmail.com

Is This Answer Correct ?

3 Yes

1 No

Question { HP, 8089 }

What are the challenges of Dataware housing in the future?

Answer

Doveloping Programing tools also

Is This Answer Correct ?

1 Yes

2 No

Question { 10231 }

Which is costliest transformation? costly means occupying
more memory?

Answer

Look up Transformatoin only,
its going to maintain existing data also in cach memory

Is This Answer Correct ?

7 Yes

0 No

Question { TCS, 13387 }

suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how

Answer

I have a idea after sql transformation go thruogh 2 Agg
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans

I am not confident check itonce let me know,,

Thanks
Srinu

Is This Answer Correct ?

5 Yes

17 No

Question { 29022 }

Why Fload doesn’t support multiset table?

Answer

Fast Load will load the Data Fastly,
Mean Concurrently,Bulk Insert.
Internally TeraData server will Create
Bulk insert DML statament
(Like: insert into Table1 as sel * from Table2
with data)
For Fast Performence it will not support the
duplicate values,Refential Intigrity,,,,

If u know the Better answer compare to this let me Know,
srinu.srinuvas@gmail.com

Is This Answer Correct ?

0 Yes

15 No

Question { 16551 }

Why AMP & PE are called Vprocs?

Answer

Vprocs:Virtual process
From PE to AMP (This is the network root via MSP(messege
passing layer),The processing data will store in Disks
(These are Physical disks),Each Amp have too many P.disks,
to migrate these P.disks The Bynet Network maintains
Virtual disks.Thses V.disks will responsible for data
migration.
That y we called this process is Virtual Process(VPROCS).

I think it will help u,,,,,

Is This Answer Correct ?

0 Yes

15 No

Question { TCS, 52931 }

Explain about Skew Factor?

Answer

The Table is having too many Duplicate rows, The Skew table
will hadle the duplicate rows up to limitations,Once its
cross the no of Rows it will effect on Performence.The Dba
people will the SKEW tables.

I think this Answer helps u

Is This Answer Correct ?

10 Yes

29 No

Question { 4376 }

sir presently i am persuing my m.tech
recently i got job in tcs as fresher presently iam doing my
9 months project related to informatica can any one guide
me how to create fact tables what type of schemas must be
used and so on if so give ur mail ids so that i can contct
through it

Answer

Fact tables will created by
(DBA people or senior architects) with PK-FK relation.
Mstly people will create PK-FK relation in facts After
loading the Data in Table).

Schemas : Mostly STAR Schema.

It will be useful for u ,,,,,,,,,,,

srinu.srinuvas@gmail.com

Is This Answer Correct ?

2 Yes

0 No

Question { 23310 }

How a Referential integrity is handled in Teradata?

Answer

TPUMP

Is This Answer Correct ?

7 Yes

17 No

Question { Accenture, 17477 }

Diff B/W
MAP Parameter,
SESSION Paramater,
DataBase connection session parameters.?

Its possible to Create 3parameters at a time?

If Possible which one will fire FIRST?

Answer

Lokendra,The order was ok,
Diff b/w them,which one is best

Is This Answer Correct ?

0 Yes

0 No