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.

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

What is the need for an etl tool?

0 Answers  

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

0 Answers   IBM,

Explain what are the different versions of informatica?

0 Answers  

How to load duplicate records in to a target table which has a primary key?

2 Answers  

Write the advantages of partitioning a session?

0 Answers  

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

What is InformaticaPowerCenter?

0 Answers   Informatica,

What is workflow? What are the components of workflow manager?

0 Answers