Interview Questions Answers in Informatica, SQL PLSQL, ETL, Shell Script

vikram p

{ City } pune
< Country > india
* Profession * informatica developer
User No # 122958

Total Questions Posted # 9
Total Answers Posted # 3

Total Answers Posted for My Questions # 5
Total Views for My Questions # 17279

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0

Questions / { vikram p }

Questions Answers Category Views Company eMail

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

Saama Tech,

Informatica 1560

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

IBM, Saama Tech,

1 SQL PLSQL 2986

Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

IBM, Saama Tech, Wipro,

1 ETL 1798

How to increase performance without changing anything in mapping.( In prod)

IBM, Saama Tech, Wipro,

ETL 1204

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

IBM, Saama Tech, Wipro,

ETL 1135

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

ETL 1269

How to find duplicate record in file using shell script?

IBM, Saama Tech, Wipro,

Shell Script 1324

What are the different ways to deploy the code in informatica?

IBM, Saama Tech, Wipro,

1 ETL 2341

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

Accenture, Saama Tech, TCS,

2 ETL 3662

Answers / { vikram p }

Question { 4616 }

what is the advantage of persistent cache? when it should be
used?

Answer

If you are using multiple look up transformations on same table, at that time you can use persistent named cache.

Is This Answer Correct ?

0 Yes

0 No

Question { 8699 }

we have 1 source table containing 100 records. now we have
to transfer first set of 1-10 (i.e1-10) records to one
target table and another set of 1-10(11-20) records to
other target table and continue like that till 100th record

Answer

Use seq. Generator to create sequence or you can use expression transformation to create sequence, then in router transformation create 10 group and give conditions like seq >1 and seq <11, seq>11 and seq <20 etc.

Is This Answer Correct ?

0 Yes

0 No

Question { Accenture, 3662 }

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

Answer

Thank you manali,
But can you please explain why joiner is better than lookup??

Is This Answer Correct ?

0 Yes

0 No