Interested to Buy Any Domain ? << Click Here >> for more details...
Find a way to implement the following logic :
You have column like :
Column 1
AA|BB|CC
DD|EE|FF
WW|AA
I need to get the length of the column without the ‘|’ .
- 5 Answers
- 9340 Views
- I also Faced
- E-Mail Answers
Answer Posted / shaik
write dql command replace to remove the | and save the result in variable port.find the length of that port by using lenth().....
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the Rank index port in Rank transformation?
What is flashback table ? Advance thanks
Make a note of the quantity vaults made in informatica?
update strategy transformation in informatica
How we can create indexes after completing the loan process?
How can we use mapping variables in informatica? Where do we use them?
Define sessions in informatica etl?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is Data Caches size?
What is meant by incremental aggregation?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the status code in stored procedure transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
What is joiner transformation?
