Answer / jvdwhinfo

Hi All,

Sources in Informatica can differ from Client to Client and
project to project.
But mostly client will send sample data through flat files.
And the metadata of the sample data is imported from Source
analyzer by clicking on the option import from file.

I hope i gave the relevant answer.
If am wrong please let me know.

Thanks.
James.

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

---

What are the limitations of joiner transformation?

0 Answers   Informatica,

---

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

---

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,

---

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,

---

How do you use reject loader.

0 Answers  

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  

---

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---