Answer / hariprasad_pulluru

Hi,

You can also parse the string using replace chr to
elminate '|' and find the length of the column

Answer / shaik

write dql command replace to remove the | and save the result in variable port.find the length of that port by using lenth().....

Answer / abhinav prakash

Replacechr(1,Column_name,'|',NULL)..write the query in
expression and pass it to Output.

Answer / ankit kansal

An Easy Way Of Achieving The Output Will Be :-

select length(column_name)-(length(cloumn_name)-length(replace(column_name,'|',''))) from table_name;


http://deepinopensource.blogspot.in/

Answer / abhinaw prakash

We can find the position of the "|" using INSTR function and
then we can use the SUBSTR function to extract the strings.
We can use Normalizer t/r to put the strings in one column
and then use LENGTH function to find the length of the string.

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

What are differences between Informatica 7.1 and 6.1

3 Answers  

What is the benefit of partitioning a session?

0 Answers  

define galaxy repository in informatica

0 Answers  

what is upstream and downstream transformation?

7 Answers  

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

Which transformation should we use to normalize the COBOL and relational sources?

4 Answers   DELL, IBM, Lehman Brothers,

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,