Interview Questions Answers in Informatica

Questions / { james }

Questions Answers Category Views Company eMail

On a day, I load 10 rows in my target and on next day if I
get 10 more rows to be added to my target out of which 5 are
updated rows how can I send them to target? How can I insert
and update the record?

Answer

Hi Guys,

For the above req. we can't use SCD 1 or 2 or 3.
Bcoz for scd1 it inserts the new record and updates the
updated record.And here we wont be having any updated
records only new records will be there.

So according to me,the best option for the above scenario
is go with Incremental aggregation.

Please let me know if you have suggestions regarding this.

Thanks,
James.

Is This Answer Correct ?

1 Yes

0 No

Question { Cap Gemini, 28135 }

how to run 2 workflows sequentially. plz respond what is the
process?

Answer

Hi Guys,

We can run 2 sequentially by scheduling the workflows at
the same time.

Is This Answer Correct ?

1 Yes

3 No

Question { CTS, 8797 }

Hi,

Can you please send me the Informatica 8 certification exam
dumps to my email id rwork.san@gmail.com

Thanks,
Revathi.

Answer

Hi Revathi,

Please send the certification dumps to my
mail id jvdwhinfo@gmail.com

Is This Answer Correct ?

0 Yes

0 No

Question { HCL, 11989 }

if soource is having 10 records how will u insert 20
records to target

Answer

Take two target instances in the mappings
This will load 20 records in the target

Is This Answer Correct ?

2 Yes

0 No

Question { TCS, 18430 }

Which will beter perform IIf or decode?

Answer

Decode function has better performance than IIF function,
bcoz for multiple conditions we have to use nested queries
when u r going with IIF whereas with Decode u don't have to
write nested queries.

Is This Answer Correct ?

6 Yes

0 No

Question { TCS, 7528 }

How to delete the (flat file) data in the target table after
loaded.

Answer

whatever data u want to delete from target table,simply go
with truncate option.

Is This Answer Correct ?

1 Yes

14 No

Question { Accenture, 114054 }

I cleared Informatica certification Designer. if anybody
need dumps, can contact at mukesh1009@gmail.com

Answer

Hi Mukesh,

My name is James.
Am looking for informatica certification
Please send the certification dump to my
mail id jvdwhinfo@gmail.com.

Thanks in advance.

Is This Answer Correct ?

0 Yes

0 No

Question { 12142 }

major difference between normal loading and bulk loading?

Answer

The major difference is while going with normal load,we can
have session recovery whereas in Bulk loading we can't.
Some of the other differences are as follows:
Normal Bulk
1.Enters session log before 1.Doesn't enter the session
loading into target there by log and loads directly in
increasing the loading time. target there by decreasing
the loading time.
2.Less performance. 2.High performance.
3.Indexing possible. 3.No concept of indexing.
4For small amount of data. 4.For huge amount of data.

Please let me know if you have any further differences.
Thanks.

Is This Answer Correct ?

2 Yes

0 No

Question { TCS, 8402 }

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

Answer

Answer 4 is absolutely correct.
Bcoz third condition is i>2 ,
so u won't be getting the second recond.

If my justification is wrong please correct it
with proper answer don't simply click on NO

Is This Answer Correct ?

6 Yes

2 No

Question { EDS, 17102 }

1,If there are 3 workflows are running and if 1st workflow
fails then how could we start 2nd workflow or if 2nd
workflow fails how could we start 3rd workflow?

Answer

When 3 workflows are running sequentially,we can definitely
give the dependancy condition by using LINK condition
between the first two workflows as "Failed".
i.e. the second workflow gets started only when first
workflow is failed and same can be applied between second
and third workflows.
Guys any suggestions please let me know.

Thanks,
James.

Is This Answer Correct ?

6 Yes

1 No

Question { TCS, 9876 }

3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?

Answer

I agree with you Chinni.
But my suggestion is instead of loading huge amount of data
at a time,we can always split the source if it is a file
using unix and extract the data from all the source files
using indirect type and load into target.

Please let me know if you have any suggestions.

Thanks.
James.

Is This Answer Correct ?

0 Yes

0 No

Question { Satyam, 7074 }

my source having the records like

ram 3
sam 5
tom 8

and i want to load into target like ram record 3 times,sam
record 5 times, tom record 8 times

Answer

Hi Guys,

we can get the desired result set using Java t/r applying
for loop.

Please let me know if you have any suggestions.

Thanks,
James.

Is This Answer Correct ?

1 Yes

1 No

Question { Cap Gemini, 12351 }

source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000

Answer

select name,no,sal,(select max(sal) from emp) as max_sal
from emp;

Is This Answer Correct ?

13 Yes

0 No

Question { Cap Gemini, 12351 }

source target
--------- --------
name no sal name no sal max_sal
r 10 1000 r 10 1000 3000
y 20 3000 y 20 3000 3000

Answer

Hey Babu,

I've tried your query.
It's not working for me.
Please double check it.

And u said my query doesn't work.
It works absolutely fine for me.
Please let me know where my went wrong.

Waiting for your reply.
-James

Is This Answer Correct ?

0 Yes

0 No

Question { 5260 }

what is semi-additive fact?where did u used?

Answer

Semi-additive facts are the measures in which they can be
added in some dimensions and cannot be added in some
dimensional tables.They are used in fact table loading.

Is This Answer Correct ?

1 Yes

1 No