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)

What are the differences between source qualifier and joiner transformation?

0 Answers  

---

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers   Cognizant, IBM,

---

How would you copy the content of one repository to another repository?

0 Answers  

---

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 Answers  

---

we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?

2 Answers  

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

Explain what is informatica metadata and where is it stored?

0 Answers  

---

What is the maplet?

0 Answers   Informatica,

---

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  

---