Answer / saket

Separate VENKATESH ,101
Rajesh,102
Siva ,103 by using "||" as delimiter .


Then in the expression Divide the string Venkatesh ,101 intto two separate variable using string operation and output that two separate columns of the target

Answer / sreekanth

when at the time of this kind of situation we can normally
import the source definitions by treat consecutive
delimiters as one and use the normalizer transformation and
set occurenc
as one and connect those ports to next transformations.

Answer / vijaya

two types
treat consecutive delimiters as one in import from flat file
then use a normalizer transformation you will get the answer

second type in unix scripting you can get the o/p

Answer / venkateshmalneni

hai vijaya


will u please explain me in detail

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  

---

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

---

Using Expression transformation how to remove duplicate records from a relational source?

4 Answers  

---

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

---

What are Business Components in Informatica?

1 Answers  

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

2 Answers   Sapient,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

---

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,

---

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,

---

What is xml source qualifier transformation in informatica?

0 Answers  

---