Answer / krishna

by using thie function sbustr(column_name,10,15) in the exp
t/r, u can get the output.

Answer / bala

substr(col_name,10,5)

Answer / gyana

SUBSTR(COLUMN_NAME,STARTING POSITION(10),NUMBER OF CHARACTER YOU WANT(5));

IT WILL GIVE YOU THE OUT PUT 10TH POSITION TO 15 TH CHARACTER STRING

Answer / usha

substrin (sivasubramaniamramakrishnan,11,5)

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

Major difference between SQL override and Lookup Sql override

1 Answers  

---

why we are using surogate key in real time give me explanation

2 Answers   TCS,

---

how we do performence tuning in informatica

3 Answers  

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

---

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)

1 Answers  

---

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

---

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

---