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 # 11750

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 1062

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 2190

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

IBM, Saama Tech, Wipro,

1 ETL 1080

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

IBM, Saama Tech, Wipro,

ETL 775

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

IBM, Saama Tech, Wipro,

ETL 775

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

ETL 822

How to find duplicate record in file using shell script?

IBM, Saama Tech, Wipro,

Shell Script 835

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

IBM, Saama Tech, Wipro,

1 ETL 1573

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 2638



Answers / { vikram p }

Question { 3692 }

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 { 7548 }

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, 2638 }

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