Answer / venky

output1=substr(name,1,instr(name,' ')-1)
output2=substr(name,instr(name,' ')+1)


output1 means firstname
output2 means last name

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

---

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

What is informatica? What exactly are the practical uses in real world

2 Answers  

---

what is the size of your data warehousing?

0 Answers   IBM,

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,

---

What is a command that used to run a batch?

4 Answers  

---

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,

---

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

---

How do you load only null records into target?

0 Answers  

---

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,

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---